REGEXP_INSTR

The function evaluates strings using characters as defined by the input character set. It returns an integer indicating the beginning or ending position of the matched substring, depending on the value of the return_option argument.

Syntax

REGEXP_INSTR(string, pattern to search, position to begin search, nth occurrence to search for, return_option, case sensitivity parameter)