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!

Using Like Operator in a decode function

AHSJul 26 2010 — edited Jul 26 2010
Hi,

I am trying to find out if I can use the like operator in a decode function
like:

select decode(1234,like '%123%','123 is a match') from dual;
this reults in error ORA-00936: missing expression

is there any way to make this work?

thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 23 2010
Added on Jul 26 2010
7 comments
43,954 views