1.

What is translate in Oracle?

Answer»

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.


Discussion

No Comment Found

Related InterviewSolutions