Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / Conversion Functions

 

Using the TRANSLATE() Function

TRANSLATE(x, from_string, to_string) convert the occurrences of characters in from_string found in x to corresponding characters in to_string. SQL> SELECT TRANSLATE('THIS IS A DEMO',   2                   'ABCDEFGHIJKLMNOPQRSTUVWXYZ',   3                   'EFGHIJKLMNOPQRSTUVWXYZABCD') FROM dual; TRANSLATE('THI -------------- XLMW MW E HIQS SQL>