Read Best Answer

Editorial / Best Answer

Answered by: Saumendra Mohanty

• May 16th, 2006

---

Both Replace and Translate are single row functions in Oracle 9i.

The Replace Function replaces single character with multiple characters.

But in Translate Function replaces sinlge character with sinlge character only.

Manickavel

• Dec 26th, 2016

Translate is used for character by character substitution where as Replace is used for substituting a character with a word

shaikh siraj

• Apr 24th, 2016

String to string changing is called as replace.
Character to character changing is called as translate.

Improve Answer