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!
Hi All,
How to use NVL Inside Decode with Dates -
Sample -
SUM(decode(oola.source_type_code,
'INTERNAL',
DECODE(NVL(TO_CHAR(oola.schedule_ship_date, 'DD-Mon-YYYY'),
'No'),
'No',
'Yes'),
'yes'))