All Products
Search
Document Center

HEXTORAW

Last Updated: Jun 18, 2021

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             |
+------------------+