SQL Translate

This will replace the set of characters, character by character.

     Syntax: translate (string, old_chars, new_chars)

     Ex:

          SQL> select translate('india','in','xy') from dual;

TRANS

--------

xydxa