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-----abbbbSQL>SQL>