Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

Translate replaces a string character by character

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(' ----------- MiSSiSSippi SQL>