The default is 0, which returns the starting position of the pattern in the target.
A value of 1 returns the starting position of the next character following the pattern match.
SQL>
SQL> SELECT REGEXP_INSTR('This is a test','a',1,2,0) position
2 FROM dual;
POSITION
----------
0
SQL>