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