Snippet Name: RAWTOHEX
Description: 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.
Also see: » Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» UNISTR
» TRANSLATE
» TO_YMINTERVAL
» TO_TIMESTAMP_TZ
» TO_TIMESTAMP
» TO_SINGLE_BYTE
» TO_NUMBER
» TO_NCLOB
» TO_NCHAR
» TO_MULTI_BYTE
» TO_LOB
» TO_DSINTERVAL
» TO_DATE
» TO_CLOB
» TO_CHAR
» TO_BINARY_FLOAT
» TO_BINARY_DOUBLE
» TIMESTAMP_TO_SCN
» SCN_TO_TIMESTAMP
» ROWIDTONCHAR
» ROWIDTOCHAR
» REFTOHEX
» RAWTONHEX
» NUMTOYMINTERVAL
» NUMTODSINTERVAL
» HEXTORAW
» DECOMPOSE
» CONVERT
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 05th, 2009
|
RAWTOHEX(<raw_value>)
-- The following hypothetical example returns the
-- hexadecimal equivalent of a RAW column value:
CREATE TABLE graphics (
raw_column RAW(10));
SELECT RAWTOHEX(raw_column) "Graphics"
FROM graphics;
Graphics
--------
7D
|