Regular Expressions Functions Oracle PLSQL Tutorial

SQL>
SQL> SELECT REGEXP_SUBSTR('abbbb','ab*') FROM dual;
REGEX
-----
abbbb