SQL>SQL> SELECT REGEXP_INSTR('This is a test','a',1,2,1) position 2 FROM dual; POSITION---------- 0SQL>