Oracle® Database SQL Reference 10g Release 2 (10.2) Part Number B14200-02 |
|
|
View PDF |
Syntax
Purpose
RAWTOHEX
converts raw
to a character value containing its hexadecimal equivalent. The raw
argument must be RAW
datatype.
You can specify a BLOB
argument for this function if it is called from within a PL/SQL block.
Examples
The following hypothetical example returns the hexadecimal equivalent of a RAW
column value:
SELECT RAWTOHEX(raw_column) "Graphics" FROM graphics; Graphics -------- 7D