SQL Replace

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