RAWTOHEX

Syntax

Description of the illustration rawtohex.gif

Purpose

RAWTOHEX converts 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 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.

Examples

The following hypothetical example returns the hexadecimal equivalent of a RAW column value:

SELECT RAWTOHEX(raw_column) "Graphics"
   FROM graphics;

Graphics
--------
7D