REGEXP_SUBSTR returns part of a string.
The complete syntax of REGEXP_SUBSTR is:
REGEXP_SUBSTR(String to search, Pattern, [Position, [Occurrence, [Return-option, [Parameters]]]])
SQL>
SQL> SELECT REGEXP_SUBSTR('Yababa dababa do','a.a') FROM dual;
REG
---
aba
SQL>