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


1 to 20 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)

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 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 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 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 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)

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 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 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 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 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 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 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 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 Concepts, 11g Release 1 (11.1)

Schema Object Dependencies

6 Schema Object DependenciesIf the definition of object A references object B, then A depends on B. This chapter explains … you almost never have to explicitly recompile A after you change B. Topics: Overview of Schema Object … Dependencies Querying Object Dependencies Object Status Invalidation of Dependent Objects … Guidelines

Database Concepts, 11g Release 1 (11.1)

The Data Dictionary

Database Object MetadataThe DBMS_METADATA package provides interfaces for extracting complete definitions of database objects. The definitions can be expressed either as XML or as SQL DDL. Two styles of interface are provided: A flexible, sophisticated interface for programmatic control A simplified interface for ad hoc querying See Also: Oracle Database PL/SQL Packages and Types Reference for more information about DBMS_METADATA

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 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)

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