Regular Expressions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Regular Expressions
  4. Add anchors or wildcard match characters as need be
SQL>
SQL> -- Add anchors or "wildcard" match characters as need be.
SQL>
SQL> SELECT REGEXP_INSTR('Hello','^.',2)  FROM dual;
REGEXP_INSTR('HELLO','^.',2)
----------------------------
                           0
SQL>