| 18. 2. 2. REGEXP_INSTR(x, pattern [, start [, occurrence [, return_option [, match_option]]]]) searches for pattern in x. |
|
|
REGEXP_INSTR() returns the position at which pattern occurs. |
The position starts at number 1. |
The following example returns the position that matches the regular expression l[[:alpha:]] {4} using REGEXP_INSTR(): |
|
SQL> SELECT REGEXP_INSTR('abcedfghijklumnoprstuvwxyzabcedfghijklumnoprstuvwxyzabcedfghijklumnoprstuvwxyz', 'l[[:alpha:]]{4}') AS result
2 FROM dual;
RESULT
----------
12
SQL>
|
|