Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Regular Expressions Functions

 

The Return-option is set to 1 to indicate the end of the found pattern

SQL> SQL> SELECT REGEXP_INSTR('This is a test','a',1,2,1) position   2  FROM dual;   POSITION ----------          0 SQL>