Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
|
|
View PDF |
Syntax
Purpose
HEXTORAW
converts char
containing hexadecimal digits in the CHAR
, VARCHAR2
, NCHAR
, or NVARCHAR2
character set to a raw value.
This function does not support CLOB
data directly. However, CLOB
s can be passed in as arguments through implicit data conversion.
See Also:
"Datatype Comparison Rules" for more information.Examples
The following example creates a simple table with a raw column, and inserts a hexadecimal value that has been converted to RAW
:
CREATE TABLE test (raw_col RAW(10)); INSERT INTO test VALUES (HEXTORAW('7D'));