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!

SELECT CASE WHEN '' IS NOT NULL...

776077Jun 20 2012 — edited Jun 20 2012
Hello, please, can someone explain this behavior?
SELECT CASE WHEN '' IS NOT NULL THEN 'result' END FROM dual;
--> null
Ok, so '' is null. But when I add "ELSE NULL", suddenly '' IS NOT NULL:
SELECT CASE WHEN '' IS NOT NULL THEN 'result' ELSE NULL END FROM dual;
--> 'result'
Thanks...
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 18 2012
Added on Jun 20 2012
6 comments
17,906 views