The Oracle and PL/SQL REPLACE function replaces a sequence of characters in a string with another sequence of characters.
The general format is:
REPLACE(char, search[,replace])
Example 1:
SELECT REPLACE('JOHN WILLIAMS','WILLIAMS','MALKOVICH') FROM DUAL;
returns:
JOHN MALKOVICH
Example 2:
SELECT REPLACE('JOHN WILLIAMS','I',' ') FROM DUAL;
returns:
JOHN W LL AMS