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 : 20.4. Differences Between Object Views and Object Tables
object types
  18.1.1. Terminology
  18.1.4.2. Classification
  constructor methods
    18.3.1. About Object Types
    18.4.1.1. Constructors
  data dictionary entries : 18.6.1. Data Dictionary
  defining : 18.2.2. Defining the Object Type Body
  forward type definitions : 18.3.5.1. Forward type definitions
  instantiating objects from : 18.2.2.1. PL/SQL usage
  modifying : 18.6.3. Schema Evolution
  renaming : 18.6.3. Schema Evolution
  syntax for : 18.3. Syntax for Creating Object Types
  type modifiers : 18.2.3. Adding Complex Data Structures
object views : 20. Object Views
  data dictionary entries : 20.7.1. Data Dictionary
  duplicate OIDs in : 20.4.1.1. Duplicate OIDs in a single view
  example of : 20.1. Example: Using Object Views
  INSTEAD OF triggers and : 20.2. INSTEAD OF Triggers
  object tables versus : 20.4. Differences Between Object Views and Object Tables
  privileges : 20.7.2. Privileges
  REFs and : 20.4.2. Using REFs with Object Views
  schema evolution and
    20. Object Views
    20.6. Schema Evolution
  syntax for : 20.3.1. CREATE VIEW: Creating an Object View
object-oriented programming
  18. Object Types
  18.1.5. Object Programming Themes
  18.7. Making the Objects Option Work
  object views and : 20. Object Views
objects : 18.1. Introduction to Oracle8 Objects
  assigning : 18.4.1.2. Direct assignment
  collections as object types : 19.2.1.2. Collection as an attribute of an object type
  comparing : 18.3.6. Comparing Objects
  database structure for : 18.2.2.2. DDL usage
  dependency of : 23.6.1. Displaying Object Dependencies
  desc command (SQL*Plus) : 18.6.2. SQL*Plus "Describe" Command
  destroying : 18.5.3. Approach 3: Do Everything via Methods
  dot notation : 18.3.4. Dot Notation
  equality of, testing : 18.3.6.2. Equality comparisons
  examples of
    18.1.2. Some Simple Examples
    18.2. Oracle Objects Example
  handles for : (see identifiers)
  identifiers : (see OIDs)
  in packages : 16.1.4. Object Persistence
  index-by tables of : 25.4.8. Use Index-By Tables of Records and Objects
  inheritance : 18.1.4.3. Inheritance
  initializing : 18.4.1. The Need to Initialize
  instantiating : 18.2.2.1. PL/SQL usage
  LOBs (large objects) : 1.4.7.6. Large object support
    functions for : 13.2. LOB Function Descriptions
  object views : 1.4.7.4. Object views
  object-oriented model support : 1.4.7.1. Support for an object-oriented model
  OIDs (object identifiers) : 18.4.2.1. Object identifiers (OIDs)
  persistent, modifying : 18.5. Modifying Persistent Objects
  privileges : 18.3.7. Privileges
  referring to : 18.4.2. OID, VALUE, REF, and DEREF
  REFs : (see REFs)
  returnin value of : 18.4.2.4. DEREF
  self-reference : (see SELF object)
  stored
    (see also stored objects)
    23. Managing Code in the Database
    managing with SQL*Plus : 23.5. Managing Stored Objects with SQL*Plus
    viewing with SQL : 23.6. Using SQL to Examine Stored Objects
  synonyms for : 23.2.2. Creating Synonyms for Stored Objects
OCI routines, for external procedures : 21.5. OCI Service Routines
OIDs (object identifiers) : 18.4.2.1. Object identifiers (OIDs)
  uniqueness of
    20.4.1. OID Uniqueness
    20.4.4. REFs to Nonunique OIDs
  where stored : 18.4.2.1. Object identifiers (OIDs)
one-dimensionality of tables : 10.2. Characteristics of PL/SQL Tables
OODBs (object-oriented databases) : 18.1. Introduction to Oracle8 Objects
OPEN statement
  (see also cursors)
  6.2.2. Cursor Operations
  6.5. Opening Cursors
  6.10.2. Opening Cursors with Parameters
  with cursor variables : 6.12.4. Opening Cursor Variables
  OPEN FOR statement : 6.12.4. Opening Cursor Variables
OPEN_CURSOR function : C.14.14. The OPEN_CURSOR function
OPEN_CURSORS parameter : 6.8.1. Maximum Number of Cursors
opening cursors
  6.2.2. Cursor Operations
  6.5. Opening Cursors
  6.10.2. Opening Cursors with Parameters
  6.12.4. Opening Cursor Variables
operating sytem files : C.17. UTL_FILE
operators, REFs as : 18.4.2.2. REFs
optimizing foreign key lookups : 10.9.5. Optimizing Foreign Key Lookups with PL/SQL Tables
OR REPLACE predicate : 18.3.2. CREATE TYPE and DROP TYPE: Creating and Dropping Types
Oracle
  how PL/SQL fits in : 1.1. What Is PL/SQL?
  programming in : (see coding)
Oracle/AQ : (see advanced queuing)
Oracle Forms : 1.2. The Concept of Programming in Oracle Applications
  code of : 1.2. The Concept of Programming in Oracle Applications
Oracle Lock Management (OLM) services : C.7. DBMS_LOCK
Oracle Reports : 1.2. The Concept of Programming 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 : 15.3.3. Anonymous Blocks in the Oracle Tools
Oracle*Mail : C.8. DBMS_MAIL
Oracle, Trusted : About the Contents
Oracle/AQ, administration on : C.3.2. DBMS_AQADM (PL/SQL 8 Only)
Oracle/AQ facility : C.3. Oracle AQ, the Advanced Queueing Facility
ORADBX tool : 25.1. Analyzing Program Performance
order, VARRAY elements : 19.4.1.4. VARRAY integration
ORDER methods : 18.3.6.1. The MAP and ORDER methods
OUT parameters
  15.6.2.2. OUT mode
  22.7.3. Assign Values to All OUT and IN OUT Parameters
  external procedure mappings : 21.4.1. Datatype Conversion
  in functions
    : 22.2.1.1. Do not use OUT and IN OUT parameters
    : 1.7.5. Structured Code and Other Best Practices
outer tables : 19.1. Types of Collections
overloaded modules
  1.6.6. Module overloading
  15.8. Module Overloading
  restrictions on : 15.8.4. Restrictions on Overloading
overloading modules : 18.1.4.4. Polymorphism

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

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.