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