Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Regular Expressions Functions

 

Return-option returns the position of the start or end of the matched string

The default is 0, which returns the starting position of the pattern in the target. A value of 1 returns the starting position of the next character following the pattern match. SQL> SQL> SELECT REGEXP_INSTR('This is a test','a',1,2,0) position   2  FROM dual;   POSITION ----------          0 SQL>