Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z

Index: O

• object tables, object views versus : Differences Between Object Views and Object Tables
• object types
• • Terminology
  • Classification
  • constructor methods
  • • About Object Types
    • Constructors
  • data dictionary entries : Data Dictionary
  • defining : Defining the Object Type Body
  • forward type definitions : Forward type definitions
  • instantiating objects from : PL/SQL usage
  • modifying : Schema Evolution
  • renaming : Schema Evolution
  • syntax for : Syntax for Creating Object Types
  • type modifiers : Adding Complex Data Structures
• object views : Object Views
• • data dictionary entries : Data Dictionary
  • duplicate OIDs in : Duplicate OIDs in a single view
  • example of : Example: Using Object Views
  • INSTEAD OF triggers and : INSTEAD OF Triggers
  • object tables versus : Differences Between Object Views and Object Tables
  • privileges : Privileges
  • REFs and : Using REFs with Object Views
  • schema evolution and
  • • Object Views
    • Schema Evolution
  • syntax for : CREATE VIEW: Creating an Object View
• object-oriented developing
• • Object Types
  • Object Developing Themes
  • Making the Objects Option Work
  • object views and : Object Views
• objects : Introduction to Oracle8 Objects
• • assigning : Direct assignment
  • collections as object types : Collection as an attribute of an object type
  • comparing : Comparing Objects
  • database structure for : DDL usage
  • dependency of : Displaying Object Dependencies
  • desc command (SQL*Plus) : SQL*Plus "Describe" Command
  • destroying : Approach 3: Do Everything via Methods
  • dot notation : Dot Notation
  • equality of, testing : Equality comparisons
  • examples of
  • • Some Simple Examples
    • Oracle Objects Example
  • handles for : (see identifiers)
  • identifiers : (see OIDs)
  • in packages : Object Persistence
  • index-by tables of : Use Index-By Tables of Records and Objects
  • inheritance : Inheritance
  • initializing : The Need to Initialize
  • instantiating : PL/SQL usage
  • LOBs (large objects) : Large object support
  • • functions for : LOB Function Descriptions
  • object views : Object views
  • object-oriented model support : Support for an object-oriented model
  • OIDs (object identifiers) : Object identifiers (OIDs)
  • persistent, modifying : Modifying Persistent Objects
  • privileges : Privileges
  • referring to : OID, VALUE, REF, and DEREF
  • REFs : (see REFs)
  • returnin value of : DEREF
  • self-reference : (see SELF object)
  • stored
  • • (see also stored objects)
    • Managing Code in the Database
    • managing with SQL*Plus : Managing Stored Objects with SQL*Plus
    • viewing with SQL : Using SQL to Examine Stored Objects
  • synonyms for : Creating Synonyms for Stored Objects
• OCI routines, for external procedures : OCI Service Routines
• OIDs (object identifiers) : Object identifiers (OIDs)
• • uniqueness of
  • • OID Uniqueness
    • REFs to Nonunique OIDs
  • where stored : Object identifiers (OIDs)
• one-dimensionality of tables : Characteristics of PL/SQL Tables
• OODBs (object-oriented databases) : Introduction to Oracle8 Objects
• OPEN statement
• • (see also cursors)
  • Cursor Operations
  • Opening Cursors
  • Opening Cursors with Parameters
  • with cursor variables : Opening Cursor Variables
  • OPEN FOR statement : Opening Cursor Variables
• OPEN_CURSOR function : The OPEN_CURSOR function
• OPEN_CURSORS parameter : Maximum Number of Cursors
• opening cursors
• • Cursor Operations
  • Opening Cursors
  • Opening Cursors with Parameters
  • Opening Cursor Variables
• operating sytem files : UTL_FILE
• operators, REFs as : REFs
• optimizing foreign key lookups : Optimizing Foreign Key Lookups with PL/SQL Tables
• OR REPLACE predicate : CREATE TYPE and DROP TYPE: Creating and Dropping Types
• Oracle
• • how PL/SQL fits in : What Is PL/SQL?
  • developing in : (see coding)
• Oracle/AQ : (see advanced queuing)
• Oracle Forms : The Concept of Developing in Oracle Applications
• • code of : The Concept of Developing in Oracle Applications
• Oracle Lock Management (OLM) services : DBMS_LOCK
• Oracle Reports : The Concept of Developing in Oracle Applications
• Oracle Server
• • Version 7.1 : (see Release 2.1, PL/SQL)
  • Version 7.2 : (see Release 2.2, PL/SQL)
• Oracle Tools, anonymous blocks in : Anonymous Blocks in the Oracle Tools
• Oracle*Mail : DBMS_MAIL
• Oracle, Trusted : About the Contents
• Oracle/AQ, administration on : DBMS_AQADM (PL/SQL 8 Only)
• Oracle/AQ facility : Oracle AQ, the Advanced Queueing Facility
• ORADBX tool : Analyzing Program Performance
• order, VARRAY elements : VARRAY integration
• ORDER methods : The MAP and ORDER methods
• OUT parameters
• • OUT mode
  • Assign Values to All OUT and IN OUT Parameters
  • external procedure mappings : Datatype Conversion
  • in functions
  • • : Do not use OUT and IN OUT parameters
    • : Structured Code and Other Best Practices
• outer tables : Types of Collections
• overloaded modules
• • Module overloading
  • Module Overloading
  • restrictions on : Restrictions on Overloading
• overloading modules : Polymorphism