Mega Code Archive

 
Categories / Oracle PLSQL / Regular Expressions
 

Simple demo for REGEXP_INSTR

SQL> SELECT REGEXP_INSTR('Mary has a cold','a') position FROM dual;   POSITION ----------          2 SQL>