Mega Code Archive

 

Categories / Oracle PLSQL / Regular Expressions

 

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>