Oracle function translate () Usage

I. Syntax:
TRANSLATE (string, from_str, to_str)
Ii. Purpose

Replace each character in from_str with a string after the corresponding character in to_str. TRANSLATE Is a superset of the functions provided by REPLACE. If from_str is longer than to_str, extra characters in from_str instead of to_str will be deleted from the string because they do not have replacement characters. To_str cannot be blank. Oracle interprets the NULL String as NULL. If any of the parameters in the TRANSLATE statement is NULL, the result is also NULL.

1. SELECTTRANSLATE ('Abcdefghj','Abcdef','123')FROMDual;
2. TRANSLATE (
3. --------------
4. 123456 ghij
6. SELECTTRANSLATE ('Abcdefghj','Abcdefghj','123')FROMDual;
7. TRANSL
8. ----------
9. 123456