Skip to Main Content

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!

Multiple values in NVL

942638Jun 19 2012 — edited Jun 19 2012
Hi,

I have following issue NVL(:Column , table.cloumn)... now :Column can accept multiple values... Now NVL does not support multiple values in place od :Column....

Please suggest some other way to handle the same in a query... I can't write pL/SQL code.. I want to handle it through query...


select NVL(:Column , table.cloumn) from table....

Now :Column can accept multiple values as parameter ... but NVL only support one value at a time.. Need some help how to handle multiple value as :Column can be
NULL i have to handle it through NVL...

Thanks

Edited by: user12403816 on 18 Jun, 2012 10:43 PM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 17 2012
Added on Jun 19 2012
13 comments
13,268 views