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!

How to match consecutive underscores using LIKE?

726603May 7 2010 — edited May 10 2010
Maybe it's late in the day and I'm overlooking something obvious, but I can't seem to match consecutive underscores in a string using the LIKE operator:

select case when 'abc_d_ef' like '%\_\_%' escape '\' then 'what the...?' else 'good' end from dual

=>

what the...?


What am I missing here?

Thanks,
Ben
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 7 2010
Added on May 7 2010
5 comments
1,955 views