Book HomeBook HomeSearch this book

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
The Oracle Library Navigation

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

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference