Oracle TRANSLATE() Function

TRANSLATE is a String function of Oracle. This function is used to replace the character from the given character. This function replaces one character only.

Syntax

Parameters

string1 : 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.

Return

It returns a string value.

Example 1


Oracle String TRANSLATE() Function

Example 2


Oracle String TRANSLATE() Function
Next TopicOracle String




Latest Courses