Loading…

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 )

Suggest An Answer

No suggestions avaliable!

Latest post from Oracle Interview Questions

Ask Question