Add anchors or 'wildcard' match characters as need be : Word Start End « Regular Expressions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Regular Expressions
  3. Word Start End

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>








Related examples in the same category

1."^" 'anchoring operator' and matches the beginning of a string
2.Asking for a match for a capital 'F' followed by any character
3.'$' a dollar sign is another anchoring operator and matches only the end of a string