Difference between replace and translate

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.

REPLACE TRANSLATE
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

Advertisements