Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Regular Expressions Functions

 

Matches zero or more repetitions

SQL> SQL> SELECT REGEXP_SUBSTR('Yababa dababa do','a.*a') FROM dual; REGEXP_SUBST ------------ ababa dababa SQL>