Purpose
This function converts a hexadecimal string to RAW.
Syntax
HEXTORAW (char)
Parameters
The char parameter is a hexadecimal string. The string can be of type CHAR, VARCHAR2, NCHAR, or NVARCHAR2.
Notice
An error is returned when the value of char is greater than F (with A as the smallest and Z as the largest).
Return type
This function returns data of the RAW type.
Examples
Convert the hexadecimal string AAA to RAW.
obclient> SELECT HEXTORAW('AAA') FROM DUAL;
+-----------------+
| HEXTORAW('AAA') |
+-----------------+
| 0AAA |
+-----------------+
1 row in set