The Oracle and PL/SQL TRANSLATE function replaces a set of characters in a string with another set of characters.
The general format is:
TRANSLATE(char, from_set, to_set)
Example 1:
SELECT TRANSLATE('JOHN WILLIAMS','AEIOU','43106') FROM DUAL;
returns:
Example 2:
SELECT TRANSLATE('JOHN WILLIAMS','AEIOU','aeiou') FROM DUAL;
returns:
JoHN WiLLiaMS