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!

REGEXP_SUBSTR - how to use case insensitive

2771962Jan 6 2015 — edited Jan 6 2015

I have to use REGEXP_SUBSTR with case insensitive option

while I use as below

select REGEXP_SUBSTR('search for uk123', 'UK','i' )  col_name from dual;

it shows error :  ORA-01722: invalid number

please help ..

Oracle 11.2.0.1.0

This post has been answered by Moazzam on Jan 6 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 3 2015
Added on Jan 6 2015
4 comments
3,602 views