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!

Null in case statement

user13390506May 25 2011 — edited May 25 2011
hi guys, was just wondering can i test for a null value in a case statement ie

case....
when 'test 1' then....print '1'
when null then.. print 'null'
when 'test 2' then....print '1'
else print 'fell into else'

IF my value was null would it print null or fall into the else section and print else.

Any help greatly appreciate.

Thank you.
This post has been answered by 860993 on May 25 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 22 2011
Added on May 25 2011
3 comments
206 views