You are using an outdated browser. Please upgrade to the latest version for the best experience.
How do I narrow my search results?

After you submit your search query:

  1. On the Refine Search results page, select one or more categories of products or services from the left sidebar.
  2. 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
Results for object


21 to 40 of 11682 results. previous page Prev  Next next page
Results per page:   20  | 40 | 60


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

Overview of PL/SQL

Support for Object-Oriented ProgrammingObject 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

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

Schema Object Names and Qualifiers

Schema Object Names and Qualifiers: Rules for naming schema objects and schema object location qualifiers Guidelines for naming schema

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

Using PL/SQL Subprograms

Using Object Types with IR SubprogramsTo 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

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

Syntax for Schema Objects and Parts in SQL Statements

References to Object Type Attributes and MethodsTo 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

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

Managing External Tables

System and Object Privileges for External TablesSystem 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

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

Mapping Files to Physical Devices

Example 3: Map a Database ObjectThis 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 -

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

Syntax for Schema Objects and Parts in SQL Statements

How Oracle Database Resolves Schema Object ReferencesWhen 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

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

AUDIT

Table 13-3 Schema Object Auditing OptionsObject 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

OLAP DML Reference, 11g Release 1 (11.1)

LOAD

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,

Database Concepts, 11g Release 1 (11.1)

Schema Object Dependencies

Object StatusEvery 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

Database Concepts, 11g Release 1 (11.1)

Schema Objects

Object ViewsIn 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

Database Concepts, 11g Release 1 (11.1)

Schema Object Dependencies

Object RevalidationAn 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

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

DBMS_SERVER_ALERT

Object TypesYou 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.

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

Format Models

Table 2-19 Attributes of the XMLFormat Objectthat implements the XMLFormat object follows: STATIC FUNCTION createFormat( enclTag IN varchar2

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

GRANT

Table 18-2 Object Privileges and the Operations They AuthorizeObject 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

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

Managing Index-Organized Tables

Creating Index-Organized Tables that Contain Object TypesIndex-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,

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

PL/SQL Data Types

Predefined PL/SQL Large Object (LOB) Data TypesLarge 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

Database Concepts, 11g Release 1 (11.1)

Oracle Data Types

Overview of Object Datatypes and Object ViewsObject 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

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

DBMS_CQ_NOTIFICATION

CQ_NOTIFICATION$_DESCRIPTOR Object Typetype. 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

Database PL/SQL Packages and Types Reference, 11g Release 1 (11.1)

DBMS_MGWADM

SYS.MGW_TIBRV_PROPERTIES Object Typelink. Syntax TYPE SYS.MGW_TIBRV_PROPERTIES IS OBJECT( service VARCHAR2(128), daemon VARCHAR2(128