Snippet Name: RAWTONHEX Description: RAWTONHEX converts raw to an NVARCHAR2 character value containing its hexadecimal equivalent. The value returned is always in the national character set. 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 » RAWTOHEX » NUMTOYMINTERVAL » NUMTODSINTERVAL » HEXTORAW » DECOMPOSE » CONVERT Comment: (none) Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 05th, 2009
Description: RAWTONHEX converts raw to an NVARCHAR2 character value containing its hexadecimal equivalent. The value returned is always in the national character set.
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 » RAWTOHEX » NUMTOYMINTERVAL » NUMTODSINTERVAL » HEXTORAW » DECOMPOSE » CONVERT
RAWTONHEX(<raw_value>); SELECT RAWTONHEX(raw_column), DUMP ( RAWTONHEX (raw_column) ) "DUMP" FROM graphics; RAWTONHEX(RA) DUMP ----------------------- ------------------------------ 7D Typ=1 Len=4: 0,55,0,68