Explain the difference between replace() and translate() functions in

Explain the difference between replace() and translate() functions in Oracle?

Answer»

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 )