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.

Replaces entire string at a time Replaces character one-to-one basis
Returns string if no match found Returns null if no match found

Do you think any other difference. Please comment