Regular Expressions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Regular Expressions
  4. Regexp_instr (string, pattern)
SQL>
SQL> SELECT REGEXP_INSTR('444 Oneway drive','One') where_it_is FROM dual;
WHERE_IT_IS
-----------
          5
SQL>