Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 67 of 166
make_ref::=
make_ref
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:
|
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
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|