Purpose
HEXTORAW() converts a hexadecimal string to a RAW value.
Syntax
HEXTORAW (char)
Parameters
The char parameter is a hexadecimal string. It can be of the CHAR, VARCHAR2, NCHAR, or NVARCHAR2 data type.
Notice
An error is reported when char contains a letter that is greater than F (where A is the smallest value and Z is the greatest value).
Return type
The return type is RAW.
Examples
The following example converts the hexadecimal string AAA to a RAW value.
obclient> SELECT HEXTORAW('AAA') FROM DUAL;
+-----------------+
| HEXTORAW('AAA') |
+-----------------+
| 0AAA |
+-----------------+
1 row in set