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>