Purpose
You can call this function to convert 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
charcontains a letter that is greater thanF(whereAis the smallest value andZis 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