18. 5. 2. Regexp_Substr returns a string of data type VARCHAR2 or CLOB |
|
REGEXP_SUBSTR uses regular expressions to specify the beginning and ending points of the returned string. |
The simplest format for this function is: |
REGEXP_SUBSTR(source_string, pattern_to_find) |
The general format for the REGEXP_SUBSTR function with all the options is: |
REGEXP_SUBSTR(source_string, pattern_to_find [, position,occurrence, match_parameter]) |
SQL>
SQL> SELECT REGEXP_SUBSTR('Mississippi', 'si', 1, 2, 'i') FROM dual;
RE
--
si
SQL>
SQL>
|
|