TRANSLATE

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