REF

Syntax

Purpose

In a SQL statement, REF takes as its argument a correlation variable (table alias) associated with a row of an object table or an object view. A REF value is returned for the object instance that is bound to the variable or row.

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));
INSERT INTO emp_table VALUES (10, 'jack', 50000);
SELECT REF(e) FROM emp_table e;

REF(E)
-----------------------------------------------------
0000280209420D2FEABD9400C3E03400400B40DCB1420D2FEABD9300C3E03400400B
40DCB1004049EE0000

See Also: Oracle8i Concepts.