Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle PL/SQL MAKE_REF Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: MAKE_REF

Definition:
The Oracle PL/SQL MAKE_REF function generates a REF to an object instance, such as an object view or a row. It accepts an Object Table Name and an Object Identifier Id as parameters and returns a REF value. This is useful when creating object views.

Notes:

  1. The object identifier in the object table must be primary key based.

  2. The MAKE_REF function applies an internal algorithm based on the supplied arguments to derive the REF. It does not read the supplied view to determine whether or not the object actually exists in the underlying table.

Example Syntax:

MAKE_REF (object_table, object_identifier_id);

Object Identifier Id is a unique id in the object table.

Example Usage:

The SQL query below returns the REF for the object instance with ID=100 from the OBJ_PARTS table.

SELECT MAKE_REF(OBJ_PARTS, 100) FROM DUAL;



Related Links:
 
Home      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 79 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?