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!

How to use NVL function for a parameter with comma delimited values

sreeseJul 24 2013 — edited Jul 24 2013

Gurus,

This one is baffling me.  I'm trying to use the NVL function but the parameter I'm passing into my  cursor contains multiple comma delimited values.  The NVL function is getting confused when analyzing the values.

"Where" clause in cursor...

and nvl(sn.c_attribute1,'x@#$%') in nvl(p_desig,'x@#$%')

parameter translated values...

and nvl(sn.c_attribute1,'x@#$%') in nvl('SPRT','GOOD','BAD','x@#$%') -- NVL not analyzing the alternative value properly

Any idea on how to get NVL to recognize 'x@#$%' if p_desig is null?

Thanks

Scott

This post has been answered by Frank Kulash on Jul 24 2013
Jump to Answer

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 21 2013
Added on Jul 24 2013
7 comments
1,499 views