Oracle TRANSLATE function | oracle translate
LastupdateonAugust19202221:51:21(UTC/GMT+8hours)DescriptionTheOracleTRANSLATEfunctionreturnsastringwithalloccurrencesofeachcharacterspecifiedinanotherstringas2ndargumentreplacedbyitscorrespondingcharacterspecifiedinthe3rdargument.ThisfunctiondoesnotsupportCLOBdatadirectly.However,CLOBscanbepassedinasargumentsthroughimplicitdataconversion.Syntax:TRANSLATE(expr,from_string,to_string) Theargumentfrom_stringcancontainmorecharactersthanto_string.Inthiscase,theextracharactersattheendoffrom_str...
Last update on August 19 2022 21:51:21 (UTC/GMT +8 hours) DescriptionThe Oracle TRANSLATE function returns a string with all occurrences of each character specified in another string as 2nd argument replaced by its corresponding character specified in the 3rd argument.
This function does not support CLOB data directly. However, CLOBs can be passed in as arguments through implicit data conversion.
Syntax:
TRANSLATE(expr, from_string, to_string)The argument from_string can contain more characters than to_string. In this case, the extra characters at the end of from_string have no corresponding characters in to_string. If these extra characters appear in expr, then they are removed from the return value.
An empty string cannot be used for to_string to remove all characters in from_string from the return value.
Parameters:
Name Description Data Types expr A string or character set which will be displayed after translate VARCHAR2 fro...