Results for object


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


Database Object-Relational Developer's Guide, 11g Release 1 (11.1)

Database Object-Relational Developer's Guide - Contents

ContentsConventions What's New in Object-Relational Features? Oracle Database 11g Release 1 (11.1) New Features … in Object-Relational Features Oracle Database 10 g Release 1 (10.1) New Features in Object … of the Object-Relational Model Database Features of Oracle Objects About Object Types About Object

Database SQL Language Reference, 11g Release 1 (11.1)

Datatype Comparison Rules

Object ValuesObject values are compared using one of two comparison functions: MAP and ORDER. Both functions … compare object type instances, but they are quite different from one another. These functions must be … specified as part of any object type that will be compared with other object types. See Also: CREATE

Database SQL Language Reference, 11g Release 1 (11.1)

Datatypes

Object TypesObject types are abstractions of the real-world entities, such as purchase orders, that application … programs deal with. An object type is a schema object with three kinds of components: A name, which … identifies the object type uniquely within that schema. Attributes, which are built-in types or

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Object Dependencies

About Object Dependencies and Object Invalidationstatic SQL to reference tables or views. An object that references another object is called a … dependent object, and an object being referenced is a referenced object. These references are established … at compile time, and if the compiler cannot resolve them, the dependent object being

Database SQL Language Reference, 11g Release 1 (11.1)

Schema Object Names and Qualifiers

Schema Object Naming RulesEvery database object has a name. In a SQL statement, you represent the name of an object with a … marks (\"). If you name a schema object using a quoted identifier, then you must use the double … quotation marks whenever you refer to that object. A nonquoted identifier is not surrounded by any … punctuation.

Database SQL Language Reference, 11g Release 1 (11.1)

Schema Object Names and Qualifiers

Schema Object Naming GuidelinesHere are several helpful guidelines for naming objects and their parts: Use full, descriptive, pronounceable names (or well-known abbreviations). Use consistent naming rules. Use the same name to describe the same entity or attribute across tables. When naming objects, balance the objective of keeping names short and easy to use with the objective of making names as descriptive as possible. When in

Database SQL Language Reference, 11g Release 1 (11.1)

Object Access Expressions

Object Access ExpressionsAn object access expression specifies attribute reference and method invocation … an object or REF column. If you specify expr, then it must resolve to an object type. When a type's … on the sample oe.order_item_typ object type, and then shows how you would update and select from the … object

Database SQL Language Reference, 11g Release 1 (11.1)

Schema Object Names and Qualifiers

Schema Object Naming ExamplesThe following examples are valid schema object names: last_name horse hr.hire_date \"EVEN THIS … & THAT!\" a_very_long_and_valid_name All of these examples adhere to the rules listed in \"Schema Object

Database SQL Language Reference, 11g Release 1 (11.1)

About SQL Functions

Object Reference FunctionsObject reference functions manipulate REF values, which are references to objects of specified … object types. The object reference functions are: DEREF MAKE_REF REF REFTOHEX VALUE See Also: Oracle … Database Object-Relational Developer's Guide for more information about REF datatypes

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Object Dependencies

Managing Object DependenciesThis section provides background information about object dependencies and object invalidation, and … explains how invalid objects can be revalidated. The following topics are included: About Object … Dependencies and Object Invalidation Manually Recompiling Invalid Objects with DDL Manually Recompiling Invalid Objects

Database SQL Language Reference, 11g Release 1 (11.1)

About SQL Functions

Large Object FunctionsThe large object functions operate on LOBs. The large object functions are: BFILENAME EMPTY_BLOB, EMPTY_CLOB

Database Administrator's Guide, 11g Release 1 (11.1)

Transaction Processing in a Distributed System

Schema Object Name Resolutionuser that issued the SQL statement, object resolution continues as if the remote user had issued the … rules: Type of Link Specified Location of Object Resolution A fixed user database link Schema specified … current user database link Current user's schema If the database cannot find the object, then it checks … public objects

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Object Name Resolution

Managing Object Name ResolutionObject names referenced in SQL statements can consist of several pieces, separated by periods. The … following describes how the database resolves an object name. Oracle Database attempts to qualify … schema, the database searches for an object whose name matches the first piece of the object name … . If it does

Database Administrator's Guide, 11g Release 1 (11.1)

Capacity Planning for Database Objects

Obtaining Object Growth Trends, where each row describes the space use of the object at a specific time. The procedure retrieves the … the following values: OBJECT_OWNER: The owner of the object. OBJECT_NAME: The name of the object … . OBJECT_TYPE: The type of the object. START_TIME: A TIMESTAMP value indicating the beginning of the … the

Database Administrator's Guide, 11g Release 1 (11.1)

Database Links

Schema Object Name Resolutiondatabase forms object names hierarchically. For example, the database guarantees that each schema within a … database has a unique name, and that within a schema each object has a unique name. As a result, a … schema object name is always unique within the database. Furthermore, the database resolves … application references to

Database PL/SQL Language Reference, 11g Release 1 (11.1)

Using Triggers

Triggers on Object TablesYou can use the OBJECT_VALUE pseudocolumn in a trigger on an object table because, as of 10 g … Release 1 (10.1), OBJECT_VALUE means the object as a whole. This is one example of its use. You can also … example of the use of OBJECT_VALUE in a trigger. To keep track of updates to values in an object table … object

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Object Dependencies

Manually Recompiling Invalid Objects with DDLYou can use an ALTER statement to manually recompile a single schema object. For example, to

Database Administrator's Guide, 11g Release 1 (11.1)

Managing Object Dependencies

Manually Recompiling Invalid Objects with PL/SQL Package Proceduresavoid application latencies that result from on-demand object revalidation. Oracle provides the … UTL_RECOMP package to assist in object revalidation. The RECOMP_SERIAL procedure recompiles all invalid

Database Administrator's Guide, 11g Release 1 (11.1)

Transaction Processing in a Distributed System

Example of Global Object Name Resolution: Complete Object NameThis example illustrates how the database resolves a complete global object name and determines the … global object name is referenced in jward 's UPDATE statement. Therefore, the system begins searching … database as user tsmith/radio. The remote database can now resolve the object reference to the emp

Database Administrator's Guide, 11g Release 1 (11.1)

Transaction Processing in a Distributed System

Example of Global Object Name Resolution: Partial Object NameThis example illustrates how the database resolves a partial global object name and determines the … database sales. The public database link in \"Example of Global Object Name Resolution: Complete … Object Name\" is already created on local database hq: CREATE PUBLIC DATABASE LINK sales.division3 … database notices that a partial





Was this page helpful?

Integrated Cloud Applications & Platform Services