The translate function performs a character-wise replacement of a string.
The syntax is as follows:
translate( input_string , string1 , string2 )
string1: this is the string that will be looked for in the input string
string2: this is the string that will replace the string1 characters in the input string.
Example:
Sql>select translate('HELLO123','L21','Ixy') from dual;
Output:
TRANSLATE
HEIIOyx3
