Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Regular Expressions Functions

 

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>