TRANSLATE

The UTL_RAW.TRANSLATE function is a byte-level translation function that converts RAW data byte by byte.

Syntax

UTL_RAW.TRANSLATE (
   r        IN RAW,    
   from_set IN RAW,    
   to_set   IN RAW  
) RETURN RAW;

Parameters

Considerations

The function scans the source byte string r byte by byte:

• If the value is found in from_set, it is replaced with the corresponding byte in to_set.
• If the byte is not found in from_set, it is copied to the result.
• If a byte in from_set does not have a corresponding byte in to_set, it is deleted.
• If from_set is longer than to_set, any extra bytes in from_set without a corresponding translation are deleted.
• If to_set is longer than from_set, any extra bytes in to_set are ignored.
• If a byte appears multiple times in from_set, only the first occurrence is considered.
• If any of the three parameters is NULL or has a length of 0, a ValueError is raised.
• If the byte string length is odd, a 0 is added to the left side during processing.

Examples

Execute the following command to use the UTL_RAW.TRANSLATE function to replace all instances of a specific character in the input byte sequence with F, while leaving other characters unchanged.

obclient> SELECT UTL_RAW.TRANSLATE('1236567812125612344434341234567890ABAA1234','12AA34','FFFFFF') FROM dual;

The result is as follows:

+-----------------------------------------------------------------------------------+
| UTL_RAW.TRANSLATE('1236567812125612344434341234567890ABAA1234','12AA34','FFFFFF') |
+-----------------------------------------------------------------------------------+
| FF365678FFFF56FFFF44FFFFFFFF567890ABFFFFFF                                        |
+-----------------------------------------------------------------------------------+