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!
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