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>