Returns the position of the second occurrence that matches the letter 'o' starting at position 10 : REGEXP_INSTR « Regular Expressions « Oracle PL / SQL
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.java2s.com Oracle', 'o', 10, 2) AS result FROM dual;