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