Mega Code Archive

 

Categories / Oracle PLSQL / Regular Expressions

 

Matchexactlyzerooronerepetition

SQL> --'?': match exactly zero or one repetition SQL> SQL> SELECT REGEXP_SUBSTR('Yababa dababa do','a.?a') FROM dual; REG --- aba SQL>