This will replace the set of characters, string by string.
Syntax: replace (string, old_chars
[, new_chars])
Ex:
SQL> select replace('india','in','xy'),
replace(‘india’,’in’)
from dual;
REPLACE REPLACE
----------- -----------
Xydia dia
