Results for REF


1 to 20 of 912 results. Prev  Next
Results per page:   20  | 40 | 60


SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 2 of 177

REFTOHEX

Application Developer's Guide - Object-Relational Features, 9i Release 2 (9.2.0.2)

Basic Components of Oracle Objects

REFThe 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

Programmer's Guide, 9i Release 2 (9.2.0.2)

Datatypes

REFThis 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

SQL Reference, 9i Release 2 (9.2.0.2)

Functions, 99 of 177

REFSyntax 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

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 121 of 134

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.

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Navigational and Type Functions, 11 of 36

ref (IN)Reference of the object. It must be pinned.

Oracle® C++ Call Interface Programmer's Guide, 9i Release 2 (9.2.0.2)

OCCI Classes and Methods, 16 of 22

Ref ClassThe 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

Programmer's Guide, 9i Release 2 (9.2.0.2)

Object-Relational Datatypes

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

Application Developer's Guide - Object-Relational Features, 9i Release 2 (9.2.0.2)

Basic Components of Oracle Objects

REF DatatypeA 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

Programmer's Guide, 9i Release 2 (9.2.0.2)

Object-Relational Datatypes

REF ExampleThis example tests two REFs for NULL, compares them for equality, and assigns one REF to another

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 118 of 134

ref (IN)REF whose size in hexadecimal representation in bytes is returned.

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 120 of 134

ref (IN)REF to test for .

Objects for OLE, 9i Release 2 (9.2.0.2)

Example: Pinning Ref Values

Example: Inserting Referenceable ObjectsOracle 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

Objects for OLE, 9i Release 2 (9.2.0.2)

Example: Pinning Ref Values

Example: Pinning Ref ValuesFeedback 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

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Navigational and Type Functions, 2 of 36

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

Programmer's Guide, 9i Release 2 (9.2.0.2)

Object-Relational Datatypes

REF Manipulation FunctionsThe 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

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Navigational and Type Functions, 3 of 36

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

Programmer's Guide, 9i Release 2 (9.2.0.2)

OCI Datatype Mapping and Manipulation Functions, 114 of 134

OCI Ref FunctionsThis 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

Utilities, 9i Release 2 (9.2.0.2)

Import

Importing REF DataREF 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

Utilities, 9i Release 2 (9.2.0.2)

Loading Objects, LOBs, and Collections

Loading REF ColumnsSQL*Loader can load real REF columns ( REF s containing real OIDs of the referenced objects … ), primary key REF columns, and unscoped REF columns that allow primary keys.





Was this page helpful?

Integrated Cloud Applications & Platform Services