Difference between TRANSLATE and REPLACE in Oracle.
Translate is used to substitute character by character. Replace is used to substitute a single character with a word