REGEXP_SUBSTR('Yababa dababa do','(ab)') : Group « Regular Expressions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Regular Expressions
  3. Group

REGEXP_SUBSTR('Yababa dababa do','(ab)')



SQL> --Backreference
SQL>
SQL>
SQL> SELECT REGEXP_SUBSTR('Yababa dababa do','(ab)') FROM dual;

RE
--
ab

SQL>








Related examples in the same category

1.Group the letters 'ir' together by putting them in parentheses
2.Parenthesize both expressions
3.Using backreference: REGEXP_REPLACE('H1234 H4321 H2345','(.*) (.*) (.*)','\3, \2 \1')
4.REGEXP_SUBSTR('Yababa dababa do','(ab)\1'), backreference option