Oracle8i SQL Reference Release 2 (8.1.6) A76989-01 |
|
Functions, 49 of 121
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:
Oracle8i Application Developer's Guide - Fundamentals for more information about object views. |
CREATE TABLE emp (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 emp; SELECT MAKE_REF(emp_view, 1, 'jack') FROM DUAL; MAKE_REF(EMP_VIEW,1,'JACK') ------------------------------------------------------ 000067030A0063420D06E06F3C00C1E03400400B40DCB10000001C26010001000200 2900000000000F0600810100140100002A0007000A8401FE0000001F02C102146A61 636B2020202020202020202020202020202000000000000000000000000000000000 00000000
|
![]() Copyright © 1999 Oracle Corporation. All Rights Reserved. |
|