Regular Expressions Oracle PLSQL

  1. Home
  2. Oracle PLSQL
  3. Regular Expressions
  4. To see the difference between and +
SQL> -- To see the difference between "*" and "+", consider the next four queries.
SQL>
SQL> -- Here, we are asking to match an "a" and zero or more "b"s:
SQL>
SQL> SELECT REGEXP_SUBSTR('a','ab*') FROM dual;
R
-
a
SQL>
SQL>