Mega Code Archive
Regexp_instr (string, pattern, position, occurence, return-option)
SQL>
SQL> -- The default (0) beginning of the position where the pattern is found:
SQL>
SQL> SELECT REGEXP_INSTR('Mary has a cold','a',1,2,0) position FROM dual;
POSITION
----------
7
SQL>