REPLACE and TRANSLATE are character function in Oracle.
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