The REPLACE function has the following general syntax:
REPLACE (string, look for, replace with)
All three arguments are necessary.
The 'look for' string will be replaced with the 'replace with' string every time it occurs.
SQL> SELECT REPLACE ('This is a test',' is ',' may be ') FROM dual;
REPLACE('THISISATE
------------------
This may be a test
SQL>