Mega Code Archive
Categories
/
Oracle PLSQL
/
Regular Expressions
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>