REGEXP_REPLACE('Oracle www.java2s.com', 'l[[:alpha:]]{4}', 'demo') : Alpha « Regular Expressions « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Regular Expressions
  3. Alpha

REGEXP_REPLACE('Oracle www.java2s.com', 'l[[:alpha:]]{4}', 'demo')


SQL>
SQL> -- REGEXP_REPLACE(x, pattern [, replace_string [, start [, occurrence [, match_option]]]])
SQL>
SQL> SELECT REGEXP_REPLACE('Oracle www.java2s.com', 'l[[:alpha:]]{4}', 'demo') AS result FROM dual;

RESULT
---------------------
Oracle www.java2s.com

SQL>
SQL>








Related examples in the same category

1.[:alpha:] matches characters only
2.REGEXP_SUBSTR('www.java2s.com Oracle','l[[:alpha:]]{4}')