Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Regular Expressions Functions

 

Asking to match an a and zero or more bs

SQL> SQL> SELECT REGEXP_SUBSTR('a','ab*') FROM dual; R - a SQL>