Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-02 |
|
|
View PDF |
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 sample schema oe
contains an object view oc_inventories
based on inventory_typ
. The object identifier is product_id
. The following example creates a REF
to the row in the oc_inventories
object view with a product_id
of 3003:
SELECT MAKE_REF (oc_inventories, 3003) FROM DUAL; MAKE_REF(OC_INVENTORIES,3003) ------------------------------------------------------------------ 00004A038A0046857C14617141109EE03408002082543600000014260100010001 00290090606002A00078401FE0000000B03C21F040000000000000000000000000 0000000000