Loading…

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.

Example

                                        

Syntax:-

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.

Suggest An Answer

No suggestions avaliable!

Latest post from Oracle Interview Questions

Ask Question