Oracle TRANSLATE Functions

TRANSLATE ('Char ', 'From _ string', 'to _ string ')

 

 

 

The return value of TRANSLATE replaces each character in from_string with the string after the corresponding character in to_string.

TRANSLATE Is a superset of the functions provided by REPLACE. If from_string is longer than to_string, extra characters in from_string instead of to_string will be deleted from char because they do not have replacement characters. To_string cannot be empty. Oracle interprets the NULL String as NULL, and if any parameter in the TRANSLATE Is NULL, the result is also NULL.

 

 

 

For example

 

Select translate ('123abc', '2dc ', '4e') from dual;

 

Since the positions of from_string and to_string correspond one to one, 2 corresponds to 4, d corresponds to e, c does not have the corresponding value, so c should be deleted.

Therefore, the 2 character in the example will be replaced with 4,

D. do not replace the string because it does not exist,

C because there is no replacement character, c in the string will be deleted

The result is:

143ab

From the point of Accumulation