Mega Code Archive

 

Categories / Oracle PLSQL / Regular Expressions

 

Returns the position of the second occurrence that matches the letter o starting at position 10

SQL> SQL> SQL> -- Returns the position of the second occurrence that matches the letter o starting at position 10 using REGEXP_INSTR(): SQL> SQL> SELECT REGEXP_INSTR('www.rntsoft.com Oracle',  'o', 10, 2) AS result FROM dual;     RESULT ----------          0 SQL> SQL>