The HEXTORAW function converts a character that contains hexadecimal digits in the CHAR, VARCHAR2, NCHAR, or NVARCHAR2 data type to the RAW data type.
Syntax
HEXTORAW (char)
Parameters
| Parameter | Description |
|---|---|
| char | The hexadecimal string. The string type can be CHAR, VARCHAR2, NCHAR, or NVARCHAR2. |
Return type
The data of the RAW data type is returned.
Examples
Execute the following statement:
select HEXTORAW('A123') from dual;
The following query result is returned:
+------------------+
| HEXTORAW('A123') |
+------------------+
| A123 |
+------------------+