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!

Case when

7870486 days ago — edited 5 days ago

Hi,
I'm fairly new to using oracle sql and having difficulty with a case when. Can someone please advise what is going wrong with the below?

case when FIELD is null then 'Missing' else FIELD end FIELD_NEW

Thanks in advance

Comments
Post Details
Added 6 days ago
2 comments
84 views