How do I narrow my search results?
After you submit your search query:
- On the Refine Search results page, select one or more categories of products or services from the left sidebar.
- Then for a category with search results, click Select to choose your product and release filters, and then click OK.
For search queries that contain multiple words, surround the query with quotes, and then resubmit your query. Example: "database cloud service"
How do I find the documentation for my product or service?
From the home page, click the technology categories for your products or services. If you do not know which category to pick, try the following features:
- Click the Find a product tab and search for your product or service.
- Click Browse All Products & Services at the bottom of the home page to view an alphabetical listing of products and services.
- Apple Safari: Version 6
- Google Chrome: Version 29 and later
- Mozilla Firefox: Version 24 and later
- Microsoft Internet Explorer: Version 9 and later
Contents → Conventions 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
Object Values → Object 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
Object Types → Object 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
About Object Dependencies and Object Invalidation → static 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
Schema Object Naming Rules → Every 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.
Schema Object Naming Guidelines → Here 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
Object Access Expressions → An 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
Schema Object Naming Examples → The 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
Object Reference Functions → Object 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
Managing Object Dependencies → This 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
Large Object Functions → The large object functions operate on LOBs. The large object functions are: BFILENAME EMPTY_BLOB, EMPTY_CLOB
Schema Object Name Resolution → user 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
Managing Object Name Resolution → Object 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
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
Schema Object Name Resolution → database 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
Triggers on Object Tables → You 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
Manually Recompiling Invalid Objects with DDL → You can use an ALTER statement to manually recompile a single schema object. For example, to
Manually Recompiling Invalid Objects with PL/SQL Package Procedures → avoid 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
Example of Global Object Name Resolution: Complete Object Name → This 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
Example of Global Object Name Resolution: Partial Object Name → This 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
Support for Object-Oriented Programming → Object types are an ideal object-oriented modeling tool, which you can use to reduce the cost and … are modular, maintainable, and reusable, object types allow different teams of programmers to … develop software components concurrently. By encapsulating operations with data, object types let you move … data-maintenance
Schema Object Names and Qualifiers → : Rules for naming schema objects and schema object location qualifiers Guidelines for naming schema
Using Object Types with IR Subprograms → To define object types for use in any schema, specify the AUTHID CURRENT_USER clause. For … information about object types, see Oracle Database Object-Relational Developer's Guide. Suppose that user HR … creates the object type in Example 8-16. Example 8-16 Creating an Object Type with AUTHID CURRENT
References to Object Type Attributes and Methods → To refer to object type attributes or methods in a SQL statement, you must fully qualify the … : CREATE TYPE cust_address_typ OID '82A4AF6A4CD1656DE034080020E0EE3D' AS OBJECT ( street_address … parentheses. For example, the sample schema oe contains an object table categories_tab, based on
System and Object Privileges for External Tables → System and object privileges for external tables are a subset of those for regular table. Only the … ANY TABLE SELECT ANY TABLE Only the following object privileges are applicable to external tables … : ALTER SELECT However, object privileges associated with a directory are: READ WRITE For external
Example 3: Map a Database Object → This example displays the block distribution at all levels within the I/O stack for the scott.bonus table. A MAP_OBJECT() operation must first be executed as follows: EXECUTE DBMS_STORAGE_MAP.MAP_OBJECT('BONUS','SCOTT','TABLE'); The query is as follows: SELECT io.OBJECT_NAME o_name, io.OBJECT_OWNER o_owner, io.OBJECT_TYPE o_type, mf.FILE_NAME, me.ELEM_NAME, io.DEPTH, (SUM(io.CU_SIZE * (io.NUM_CU -
How Oracle Database Resolves Schema Object References → When you refer to an object in a SQL statement, Oracle considers the context of the SQL statement … and locates the object in the appropriate namespace. After locating the object, Oracle performs the … operation specified by the statement on the object. If the named object cannot be found in the
Table 13-3 Schema Object Auditing Options → Object SQL Operations Table ALTER AUDIT COMMENT DELETE FLASHBACK (Note 3) GRANT INDEX INSERT LOCK … COMMENT GRANT RENAME SELECT Directory AUDIT GRANT READ Library EXECUTE GRANT Object Type ALTER … FLASHBACK audit object option applies only to flashback queries. Examples Auditing SQL Statements
object. . . → The name of a program, formula, or model. Notes Definitions Loaded on First Use All of the objects in an analytic workspace (except for programs, formulas, and models) are loaded into memory when the analytic workspace is attached. Programs, models, and formulas are loaded into memory when first used or when requested using the LOAD command. The time required for loading is small but perceptible,
Object Status → Every database object has one of the status values described in Table 6-1. Table 6-1 Database … Object Status Status Meaning Valid The object was successfully compiled, using the current definition in … the data dictionary. Compiled with errors The most recent attempt to compile the object produced … errors. Invalid
Object Views → In the Oracle object-relational database, an object view let you retrieve, update, insert, and … delete relational data as if it was stored as an object type. You can also define views with columns … that are object datatypes, such as objects, REF s, and collections (nested tables and VARRAY s). See … Also: Oracle
Object Revalidation → An object that is not valid when it is referenced must be validated before it can be used … . Validation occurs automatically when an object is referenced; it does not require explicit user action. If … an object is not valid, its status is either compiled with errors, unauthorized, or invalid. For … Errors The compiler cannot
Object Types → You qualify the metric by an individual object for the following object types. Table 115-1 Object … threshold can only be set at the instance level, which means that no object name should be specified when setting the threshold for this type of metric.
Table 2-19 Attributes of the XMLFormat Object → that implements the XMLFormat object follows: STATIC FUNCTION createFormat( enclTag IN varchar2
Table 18-2 Object Privileges and the Operations They Authorize → Object Privilege Operations Authorized DIRECTORY PRIVILEGES The following directory privileges … object serves as a pointer. The directory object contains the full path name of the operating system … . Granting object privileges on the directory database object to individual database users, rather than
Creating Index-Organized Tables that Contain Object Types → Index-organized tables can store object types. The following example creates object type admin_typ … , then creates an index-organized table containing a column of object type admin_typ: CREATE OR … REPLACE TYPE admin_typ AS OBJECT (col1 NUMBER, col2 VARCHAR2(6)); CREATE TABLE admin_iot (c1 NUMBER … primary key,
Predefined PL/SQL Large Object (LOB) Data Types → Large object (LOB) data types reference large objects that are stored separately from other data … Table 3-9. Table 3-9 Predefined PL/SQL Large Object (LOB) Data Types Data Type Description Size … large object that is stored in an external file, a LOB data type uses a LOB locator, which is stored … includes a transaction ID, so
Overview of Object Datatypes and Object Views → Object types and other user-defined datatypes let you define datatypes that model the structure and … behavior of the data in their applications. An object view is a virtual object table. See Also: Oracle Database Object-Relational Developer's Guide
CQ_NOTIFICATION$_DESCRIPTOR Object Type → type. Syntax TYPE SYS.CHNF$_DESC IS OBJECT( registration_id NUMBER, transaction_id RAW(8), dbname … , query_desc_array CQ_NOTIFICATION$_QUERY_ARRAY); Attributes Table 33-2 CQ_NOTIFICATION$_DESCRIPTOR Object … associated with the notification. Can be one of EVENT_OBJCHANGE (change to a registered object
SYS.MGW_TIBRV_PROPERTIES Object Type → link. Syntax TYPE SYS.MGW_TIBRV_PROPERTIES IS OBJECT( service VARCHAR2(128), daemon VARCHAR2(128
SQLSET_ROW Object Type → The SQLSET_ROW object models the content of a SQL Tuning Set for the user. Logically, a SQL Tuning … object ( sql_id VARCHAR(13), force_matching_signature NUMBER, sql_text CLOB, object_list sql_objects
RLM$EVENTIDS Object Type → The RLM$EVENTIDS type is defined as a table of VARCHAR2 values as follows: Syntax CREATE OR REPLACE TYPE RLM$EVENTIDS is table of VARCHAR2(38); Attributes None. Usage Notes RLM$EVENTIDS type is used to pass a list of event identifiers to the CONSUME_PRIM_EVENTS procedure. These event identifiers are ROWID s for the corresponding events in the database and their values are available through the arguments
Supported Object Types → SQL*Loader supports loading of the following two object types: column objects When a column of a … table is of some object type, the objects in that column are referred to as column objects … not have object identifiers and cannot be referenced. If the object type of the column object is … column
Partitioned Object Support → SQL*Loader supports loading partitioned objects in the database. A partitioned object in an Oracle … partitioned object support enables SQL*Loader to load the following: A single partition of a partitioned
Loading Object Tables → The control file syntax required to load an object table is nearly identical to that used to load a … typical relational table. Example 10-10 demonstrates loading an object table with primary-key-based … object identifiers (OIDs). Example 10-10 Loading an Object Table with Primary Key OIDs Control File … be able
BFILE get name object → The session waits on a call to find or generate the external name of a external large object. Wait
free process state object → Used during the creation of a process. The session will scan the process table and look for a free process slot. If none can be found, PMON is posted to check if all the processes currently in the process table are still alive. If there are dead processes, then PMON will clean them and make the process slot available to new processes. The waiting process will then rescan the process table to find
AWR_BASELINE_METRIC_TYPE Object Type → AS OBJECT ( baseline_name VARCHAR2(64), dbid NUMBER NOT NULL, instance_number NUMBER NOT NULL
MGD_ID Object Type → … Syntax CREATE OR REPLACE TYPE MGD_ID as object (category_id VARCHAR2(256), components … MGD_ID_COMPONENT_VARRAY); Attributes Table 235-3 MGD_ID Object Type Attributes Attribute Description category_id … attributes Methods Table 235-5 describes the methods of the MGD_ID object type. Table 235-4 MGD_ID … Methods Method
Data Structures - Object Types → The DBMS_DATAPUMP package defines the following kinds of OBJECT types: Worker Status Types Log … status types describe what each worker process in a job is doing. The schema, object name, and … object type of an object being processed will be provided. For workers processing user data, the … status on the last
Managing Object Privileges → An object privilege grants permission to perform a particular action on a specific schema object … . Different object privileges are available for different types of schema objects. The privilege to … delete rows from the departments table is an example of an object privilege. Some schema objects, such … as clusters,
Revoking Object Privileges → To revoke an object privilege, you must fulfill one of the following conditions: You previously … granted the object privilege to the user or role. You possess the GRANT ANY OBJECT PRIVILEGE system … privilege that enables you to grant and revoke privileges on behalf of the object owner. You can only … a cascading
SYS.MGW_PROPERTY Object Type → links, foreign queues, and subscribers. Syntax TYPE SYS.MGW_PROPERTY IS OBJECT( name VARCHAR2(500
DBMSOUTPUT_LINESARRAY Object Type → This package type is to be used with the GET_LINES Procedure to obtain text submitted through the PUT Procedure and PUT_LINE Procedure. Syntax TYPE DBMSOUTPUT_LINESARRAY IS VARRAY(2147483647) OF VARCHAR2(32767);
About Object Privileges → An object privilege is a right that you grant to a user on a database object. Some examples of … object privileges include the right to: Update a table Select rows from another user's table Execute a stored procedure of another user
JOBARG Object Type → This type is used by the JOB and JOBATTR object types. It represents a job argument in a batch of … job arguments. Syntax TYPE jobarg IS OBJECT ( arg_position NUMBER, arg_text_value VARCHAR2(4000 … ), arg_anydata_value ANYDATA, arg_operation VARCHAR2(5); Attributes Table 114-1 JOBARG Object Type
JOB Object Type → job IS OBJECT ( job_name VARCHAR2(100), job_class VARCHAR2(32), job_style VARCHAR2(11 … VARCHAR2(5), aq_job VARCHAR2(5), instance_id NUMBER); Object Attributes Table Table 114-3 describes … the attributes of the JOB object type. For more information about these attributes, see … \"SET_ATTRIBUTE Procedure\". Table 114-3 JOB Object
SCHEDULER$_STEP_TYPE Object Type → scheduler$_step_type IS OBJECT ( step_name VARCHAR2(32), step_type VARCHAR2(32)); Attributes Table … 114-6 SCHEDULER$_STEP_TYPE Object Type Attribute Description step_name Name of the step step_type
CQ_NOTIFICATION$_ROW Object Type → previously named SYS.CHNF$_RDESC. Syntax TYPE SYS.CHNF$_RDESC IS OBJECT ( opflags NUMBER, row_id VARCAHR2 … (2000)); Attributes Table 33-5 TYPE SYS.CQ_NOTIFICATION$_ROW Object Type Attribute Description
CQ_NOTIFICATION$_REG_INFO Object Type → The object type describes the attributes associated with creating a new registration. It is a … synonym for the type previously named SYS.CHNF$_REG_INFO. Syntax TYPE SYS.CHNF$_REG_INFO IS OBJECT … CQ_NOTIFICATION$_REG_INFO Object Type Attribute Description callback Name of the server side PL/SQL … modified QOS_QUERY (0x8): specifies