DIFF REPLACE &&TRANSLATE in Oracle.

REPLACE and TRANSLATE are character function in Oracle.

Replace function

Translate function

Both function looks similar but there are some subtle difference. We can say Translate is an extended version of Replace.