Oracle SQL - REGEXP_INSTR Return Value


The return option of the REGEXP_INSTR function can change the return value.

By default, the position where the pattern was found is returned.

To get the position after the found pattern, you can use the return option.

The following table shows the values you can use in the return function argument.

Return Description
0 Position of the first character of the pattern found (default)
1 Position of the first character after the pattern found

Related Topic