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