MAKE_REF

Syntax

make_ref::=

Text description of make_ref

Purpose

MAKE_REF creates a REF to a row of an object view or a row in an object table whose object identifier is primary key based.

See Also: Oracle9i Application Developer's Guide - Fundamentals for more information about object views DEREF

Example

The following example creates a REF to a row in an object view:

CREATE TABLE employee (eno NUMBER, ename VARCHAR2(20),
   salary NUMBER, PRIMARY KEY (eno, ename));
CREATE TYPE emp_type AS OBJECT 
   (eno NUMBER, ename CHAR(20), salary NUMBER);
CREATE VIEW emp_view OF emp_type 
   WITH OBJECT IDENTIFIER (eno, ename)
   AS SELECT * FROM employee;
SELECT MAKE_REF(emp_view, 1, 'jack') FROM DUAL;

MAKE_REF(EMP_VIEW,1,'JACK')
------------------------------------------------------
000067030A0063420D06E06F3C00C1E03400400B40DCB10000001C26010001000200
2900000000000F0600810100140100002A0007000A8401FE0000001F02C102146A61
636B2020202020202020202020202020202000000000000000000000000000000000
00000000