REGEXP_SUBSTR « Regular Expressions Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Regular Expressions Functions
  3. REGEXP_SUBSTR
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 (