Mega Code Archive

 

Categories / Oracle PLSQL / Char Functions

 

Translate

SQL> -- Translate: replaces a string character by character. SQL> SQL> -- RANSLATE(string, characters_to_find, characters_to_replace_by) SQL> SELECT TRANSLATE('Mississippi', 's','S') FROM dual; TRANSLATE(' ----------- MiSSiSSippi