REGEXP_SUBSTR('abbbb','ab+')
SQL> --if we have succeeding 'b's, we get the same greedy result as with '*': SQL> SQL> SELECT REGEXP_SUBSTR('abbbb','ab+') FROM dual; REGEX ----- abbbb SQL> SQL>