Regular Expressions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Regular Expressions
  4. Matchexactlyzerooronerepetition
SQL> --'?': match exactly zero or one repetition
SQL>
SQL> SELECT REGEXP_SUBSTR('Yababa dababa do','a.?a') FROM dual;
REG
---
aba
SQL>