Originally Posted by
harish31
Thanks for the reply. I want to use the above query in a stored procedure which have null values for the parameters as below:
. . . E t c . . .
My paramters will sometimes have values and some times null. I can not use IS NULL all the time. Please advise.
Two ways:
Code:
. . .
(val7 IS NULL OR Column_7 = val7) and
...
Or:
Code:
. . .
Column_7 = NVL(val7,Column_7) and
...
Last edited by LKBrwn_DBA; 02-18-2013 at 05:47 PM.
"The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb
Reply With Quote
