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

Suggest An Answer