What is translate in Oracle?
The translate function replaces the characters in a string with the new set of characters one by one. For example:- the first character in the string is replaced by the first character of the original string and so on. The translate function always returns a string value.
TRANSLATE( string1, string_to_replace, replacement_string )
String1:-the string which has to be replaced
string_to_replace:-the string that has to be searched in the string 1
replacement_string:-the new string with which string1 will be replaced.