Oracle® Database SQL Language Reference 11g Release 2 (11.2) Part Number E26088-03 |
|
|
PDF · Mobi · ePub |
RAWTOHEX
converts raw
to a character value containing its hexadecimal representation.
As a SQL built-in function, RAWTOHEX
accepts an argument of any scalar data type other than LONG
, LONG
RAW
, CLOB
, BLOB
, or BFILE
. It returns a VARCHAR2
value with the hexadecimal representation of bytes that make up the value of raw
. Each byte is represented by two hexadecimal digits.
Note:
RAWTOHEX
functions differently when used as a PL/SQL built-in function. Refer to Oracle Database Advanced Application Developer's Guide for more information.The following hypothetical example returns the hexadecimal equivalent of a RAW
column value:
SELECT RAWTOHEX(raw_column) "Graphics" FROM graphics; Graphics -------- 7D