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 not with regexp_like

user_anumosesJul 12 2010 — edited Jul 12 2010
select x.v
, case when not regexp_like( x.v , '\.[[:digit:]]{4}$') then 'ERROR' else 'OK' end mess
from
(
select 4.05 v from dual
union
select 4.0534 v from dual
)x
---------------------------
ORA-00920: invalid relational operator

Can I use this? I want to get answer that is below

------------------------
4.05 ERROR
4.0534 OK

But I am getting relational operator error. How to fix this?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 9 2010
Added on Jul 12 2010
18 comments
37,165 views