Oracle TRANSLATE() FunctionTRANSLATE is a String function of Oracle. This function is used to replace the character from the given character. This function replaces one character only. SyntaxParametersstring1 : string to be replace from sequence of characters. string_to_replace : string to be search in string for replacing. replacement_string : it is optional. String to be replace will be replaced from this string. ReturnIt returns a string value. Example 1Example 2Next TopicOracle String |