Skip to Main Content
Forums

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

Shawn MichaelsAug 6 2009 — edited Aug 6 2009
back again, . . .
does anyone have any idea on how to handle null values in a case statement?

CASE column
WHEN NULL THEN 'value'
WHEN 'value2' THEN 'valuexx'
ELSE 'othervalue'
END;
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2009
Added on Aug 6 2009
13 comments
227,413 views