7 Replies Latest reply on Jul 24, 2013 7:30 PM by sreese

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




      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?