REF → The REF function in a SQL statement takes as an argument a correlation name for an object table or … view and returns a reference (a REF ) to an object instance from that table or view. The REF … students and employees: SELECT REF(p) FROM Person_v p; The following example returns a REF to the
REF → This is a reference to a named data type. The C language representation of a REF is a variable … are retrieved from the server, they are stored in the client-side object cache. To allocate a REF for … use in your application, you should declare a variable to be a pointer to a REF, and then call
REF → Syntax ref::= Text description of ref Purpose REF takes as its argument a correlation variable … (table alias) associated with a row of an object table or an object view. A REF value is returned for … oe.cust_address_typ, inserts a row into the table, and retrieves a REF value for the object instance
ref (IN) → REF to be converted into a hexadecimal string; if ref is a REF (that is, OCIRefIsNull ( ref ) == TRUE ) then zero hex_length value is returned.
ref (IN) → Reference of the object. It must be pinned.
Ref Class → The mapping in the C++ programming language of an SQL REF value, which is a reference to an SQL … structured type value in the database. Each REF value has a unique identifier of the object it refers … to. An SQL REF value may be used in place of the SQL structured type it references; it may be used as … either a column value
REF (OCIRef) → A REF (reference) is an identifier to an object. It is an opaque structure that uniquely locates … the object. An object may point to another object by way of a REF. In C applications, the REF is
REF Datatype → A REF is a logical \"pointer\" to a row object. It is an Oracle built-in datatype. REF s and … collections of REF s model associations among objects--particularly many-to-one relationships--thus … reducing the need for foreign keys. REF s provide an easy mechanism for navigating between objects. You … cases can
REF Example → This example tests two REFs for NULL, compares them for equality, and assigns one REF to another
ref (IN) → REF whose size in hexadecimal representation in bytes is returned.
ref (IN) → REF to test for .
Example: Inserting Referenceable Objects → Oracle Objects for OLE Release 9.2 Part Number A95895-01 Home Book List Contents Master Index Feedback Example: Inserting Referenceable Objects The following example inserts the new \"PERSON\" referenceable object in the server. Before running the sample code, make sure that you have the necessary datatypes and tables in the database. See Schema Description used in examples of OraObject/OraRef. Dim
Example: Pinning Ref Values → Feedback Example: Pinning Ref Values The following example pins the attributes of the \"PERSON … (\"aperson\").Value 'access the attribute of person. This operation pins the Person ref value and
ref (OUT) [optional] → If there is an error in flushing the objects ( *ref ) will point to the object that is causing the … error. If ref is , then the object will not be returned. If *ref is , then a reference will … be allocated and set to point to the object. If *ref is not , then the reference of the object … REF
REF Manipulation Functions → The following functions perform REF operations. Function Purpose OCIRefAssign() assign one REF to … another OCIRefClear() clear or ify a REF OCIRefFromHex() convert hexadecimal string to a REF … OCIRefHexSize() return size of hex string representation of REF OCIRefIsEqual() compare two REFs for
ref (OUT) [optional] → If there is an error in refreshing the objects, ( *ref ) will point to the object that is causing … the error. If ref is , then the object will not be returned. If *ref is , then a reference … will be allocated and set to point to the object. If *ref is not , then the reference of the … object is copied into the
OCI Ref Functions → This section describes the OCI Ref functions. Table 18-6 Ref Functions Function/Page Purpose … OCIRefAssign() Assign one REF to another OCIRefClear() Clear or ify a REF OCIRefFromHex() Convert … hexadecimal string to REF OCIRefHexSize() Return size of hexadecimal representation of REF
Importing REF Data → REF columns and attributes may contain a hidden ROWID that points to the referenced type instance … VALIDATE REF UPDATE; See Also: Oracle9i SQL Reference for more information about the ANALYZE TABLE statement