Mega Code Archive

 

Categories / Oracle PLSQL / Regular Expressions

 

(match zero or more repetitions)

SQL> --'*' (match zero or more repetitions): SQL> SQL> SELECT REGEXP_SUBSTR('Yababa dababa do','a.*a') FROM dual; REGEXP_SUBST ------------ ababa dababa SQL>