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






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

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


SQL> --pattern is matched. If we use the backreference option, the query looks like this:
SQL>
SQL> SELECT REGEXP_SUBSTR('Yababa dababa do','(ab)\1')FROM dual;

REGE
----
abab

SQL>








Related examples in the same category

1.REGEXP_SUBSTR(description,'ird|irs'): Treat a pattern as a group
2.REGEXP_SUBSTR('Mississippi', 'si', 1, 2, 'i')