The general format for this function is:TRANSLATE(string, characters_to_find, characters_to_replace_by) SQL>SQL> SELECT TRANSLATE('Mississippi', 's','S') FROM dual;TRANSLATE('-----------MiSSiSSippiSQL>