Mega Code Archive

 

Categories / Oracle PLSQL / Regular Expressions

 

Regexp_instr (string, pattern)

SQL> SQL> SELECT REGEXP_INSTR('444 Oneway drive','One') where_it_is FROM dual; WHERE_IT_IS -----------           5 SQL>