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.