Mega Code Archive
Categories
/
Oracle PLSQL
/
Regular Expressions
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>