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.
| 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
