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 14272 results. Previous page Prev  Next next page
Results per page:   20  | 40 | 60


Database PL/SQL Language Reference, 11g Release 2 (11.2)

Overview of PL/SQL

Support for Object-Oriented ProgrammingPL/SQL supports object-oriented programming with \"Abstract Data Types\".

Database Object-Relational Developer's Guide, 11g Release 2 (11.2)

Database Object-Relational Developer's Guide - Contents

ContentsConventions What's New in Object-Relational Features? Oracle Database 11g Release 2 (11.2) New Features … 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-Relational Features 1 … Introduction

Database SQL Language Reference, 11g Release 2 (11.2)

Data Type 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 2 (11.2)

Data Types

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 Concepts, 11g Release 2 (11.2)

Partitions, Views, and Other Schema Objects

Object ViewsJust as a view is a virtual table, an object view is a virtual object table. Each row in the view … is an object, which is an instance of an object type. An object type is a user-defined data type. You … can retrieve, update, insert, and delete relational data as if it was stored as an object

Database Concepts, 11g Release 2 (11.2)

Tables and Table Clusters

Object TablesAn Oracle object type is a user-defined type with a name, attributes, and methods. Object types … database. An object type defines a logical structure, but does not create storage. Example 2-5 … creates an object type named department_typ. Example 2-5 Object Type CREATE TYPE department_typ AS OBJECT

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Schema Objects

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 Administrator's Guide, 11g Release 2 (11.2)

Managing Schema Objects

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 Concepts, 11g Release 2 (11.2)

Data Dictionary and Dynamic Performance Views

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, and a simplified interface for ad hoc querying. See Also: Oracle Database PL/SQL Packages and Types Reference for more information about

Database SQL Language Reference, 11g Release 2 (11.2)

Database Object Names and Qualifiers

Database 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 2 (11.2)

Single-Row Functions

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

Database Concepts, 11g Release 2 (11.2)

Tables and Table Clusters

Schema Object TypesSecurity\" to learn more about users and privileges Schema Object Types The most important schema objects … A sequence is a user-created object that can be shared by multiple users to generate integers … another schema object. Because a synonym is simply an alias, it requires no storage other than its

Database Concepts, 11g Release 2 (11.2)

Tables and Table Clusters

Schema Object Dependenciesmanage storage for schema objects Schema Object Dependencies Some schema objects reference other objects … , creating schema object dependencies. For example, a view contains a query that references tables or … other views, while a PL/SQL subprogram invokes other subprograms. If the definition of object A … references object

Database SQL Language Reference, 11g Release 2 (11.2)

Object Access Expressions

Object Access ExpressionsAn object access expression specifies attribute reference and method invocation … be an object or REF column. If you specify expr, then it must resolve to an object type. When a … based 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 2 (11.2)

Database Object Names and Qualifiers

Schema Object Naming ExamplesThe following examples are valid schema object names: last_name horse hr.hire_date \"EVEN THIS … Object Naming Rules\". The following example is not valid, because it exceeds 30 characters

Database SQL Language Reference, 11g Release 2 (11.2)

Database 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 2 (11.2)

Object Reference 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 data types

Database Administrator's Guide, 11g Release 2 (11.2)

Distributed Database Concepts

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 2 (11.2)

Managing Space for Schema Objects

Dropping Unused Object StorageBeginning with Oracle Database 11 g release 2 (11.2.0.2), the DBMS_SPACE_ADMIN package includes the DROP_EMPTY_SEGMENTS procedure, which enables you to drop segments for empty tables and partitions that have been migrated from previous releases. This includes segments of dependent objects of the table, such as index segments, where possible. The following example drops empty segments from every table

Database Administrator's Guide, 11g Release 2 (11.2)

Managing Space for Schema Objects

Obtaining Object Growth Trends, where each row describes the space use of the object at a specific time. The function retrieves the … function requires as input the following values: OBJECT_OWNER: The owner of the object. OBJECT_NAME … : The name of the object. PARTITION_NAME: The name of the table or index partition, is relevant … . Specify NULL otherwise.