Explain the difference between replace() and translate() functions in Oracle?
| S.no | REPLACE() | TRANSLATE() |
|---|---|---|
| 1. | It replaces the complete string at once | It replaces the character one by one |
| 2. | If no match is found, then it returns the string | If no match is found, then it returns the NULL value. |
| 3. | REPLACE( string1, string_to_replace [, replacement_string] ) | TRANSLATE( string1, string_to_replace, replacement_string ) |
BY Best Interview Question ON 19 Feb 2019