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!

case when statement with like

user5716448Oct 4 2017 — edited Oct 5 2017

Hi,

Using 11.2.0.3 if have case with equality operator works however when try use like get missing expression message

select ...

CASE table.col_name

            WHEN LIKE '%xyz%'

                      THEN

                           '1'                                 

                    ELSE

                           NULL     

END CASE

can you not use case and like together?

Thanks
This post has been answered by Hans Steijntjes on Oct 4 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 2 2017
Added on Oct 4 2017
4 comments
16,895 views