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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

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;

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 3 2009

Added on Aug 6 2009

13 comments

227,011 views