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