Regular Expressions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Regular Expressions
  4. 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>