TRANSLATE

Note

• char1, char2, and char3 each can be of the CHAR, VARCHAR2, NCHAR, NVARCHAR2, or CLOB data type.
• If char3 contains more characters than char2, the extra characters at the end of char3 are invalid.
• If char3 contains fewer characters than char2, the extra characters at the end of char2 are removed from the return value.
• If char3 contains 0 characters, the function returns NULL.
• If char2 contains duplicate characters, the mapping in char3 corresponding to the first occurrence of the character is used for replacement. For example, if char2 is aab and char3 is 123, the function replaces all a in char1 with 1 and all b with 3.