REFTOHEX

Syntax

Purpose

REFTOHEX converts argument r to a character value containing its hexadecimal equivalent.

Example

CREATE TYPE emp_type AS OBJECT
   (eno NUMBER, ename VARCHAR2(20), salary NUMBER);
CREATE TABLE emp_table OF emp_type 
   (primary key (eno, ename));
CREATE TABLE dept 
   (dno NUMBER, mgr REF emp_type SCOPE IS emp);
INSERT INTO emp_table VALUES (10, 'jack', 50000);
INSERT INTO dept SELECT 10, REF(e) FROM emp_table e;
SELECT REFTOHEX(mgr) FROM dept;

REFTOHEX(MGR)
------------------------------------------------------
0000220208420D2FEABD9400C3E03400400B40DCB1420D2FEABD9300C3E03400400B
40DCB1