Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Regular Expressions Functions

 

The search string cannot be anchored at the beginning and then searched from some other position

SQL> SQL> SELECT REGEXP_INSTR('Hello','^.',2)   2      FROM dual; REGEXP_INSTR('HELLO','^.',2) ----------------------------                            0 SQL>