SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

question regarding NVL function

523059May 18 2009 — edited May 18 2009

I am new to pl/sql and I have a question regarding calling the nvl function in a where clause that is using a variable?
For instance I have a variable and a where clause that says when my_var is null then ... NVL(my_var,my_proc).
So will the procedure execute even when the variable is not null?
Does that make sense?

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 15 2009

Added on May 18 2009

13 comments

2,801 views