Regexp_Substr returns a string of data type VARCHAR2 or CLOB : REGEXP_SUBSTR « Regular Expressions Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Regular Expressions Functions
  3. REGEXP_SUBSTR

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>








18.5.REGEXP_SUBSTR
18.5.1.REGEXP_SUBSTR(x, pattern [, start [, occurrence [, match_option]]]) gets a substring of x that matches pattern, which begins at the position specified by start.
18.5.2.Regexp_Substr returns a string of data type VARCHAR2 or CLOB
18.5.3.Grouping
18.5.4.Group the letters 'ir' together by putting them in parentheses and then parenthesizing the suffix using alternation
18.5.5.Backreference
18.5.6.Search for (