Mega Code Archive
Return-option is set to 1 to indicate the end of the found pattern
SQL>
SQL>
SQL> -- Return-option is set to 1 to indicate the end of the found pattern:
SQL>
SQL> SELECT REGEXP_INSTR('Mary has a cold','a',1,2,1) position FROM dual;
POSITION
----------
8
SQL>