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, I'm trying to compare two dates that are null. I would like to exclude them if they're equal to null. This doesn't seem to work.
SELECT entry_dt, exit_dt FROM SCH_ENROLLMENT WHERE nvl(exit_dt,' ') != nvl(entry_dt,' ');
How can I fix it?
Thanks.