raw to a character value containing its hexadecimal representation.
As a SQL built-in function,
RAWTOHEX accepts an argument of any scalar datatype other than
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.
RAWTOHEXfunctions 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