Returns the position of the second occurrence that matches the regular expression s[[
SQL> SQL> SELECT REGEXP_INSTR('But, soft! What light through yonder window softly breaks?', 's[[:alpha:]]{3}', 1, 2) AS result 2 FROM dual; RESULT ---------- 45 SQL>