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

Index: O

OAS: (see Oracle Application Server)

OBJECT_NAME column: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features

OBJECT_OWNER column: 8.4.3. Context Data Dictionary Views, Guide to Oracle8i Features

OCA (Oracle Client Adapter): 1.3.8.1. Oracle Lite, Oracle Web Applications

OCI: (see Oracle Call Interface)

OIDs (object identifiers)

18.4.2.1. Object identifiers (OIDs), Oracle PL/SQL Programming

uniqueness of

20.4.1. OID Uniqueness, Oracle PL/SQL Programming
20.4.4. REFs to Nonunique OIDs, Oracle PL/SQL Programming

where stored: 18.4.2.1. Object identifiers (OIDs), Oracle PL/SQL Programming

OODBs (object-oriented databases): 18.1. Introduction to Oracle8 Objects, Oracle PL/SQL Programming

OPEN FOR statement, native dynamic SQL

4.2.2. The OPEN FOR Statement, Guide to Oracle8i Features
4.6.2. Error Handling, Guide to Oracle8i Features

OPEN statement

(see also cursors)
3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features
6.2.2. Cursor Operations, Oracle PL/SQL Programming
6.5. Opening Cursors, Oracle PL/SQL Programming
6.10.2. Opening Cursors with Parameters, Oracle PL/SQL Programming
OPEN FOR statement: 6.12.4. Opening Cursor Variables, Oracle PL/SQL Programming
with cursor variables: 6.12.4. Opening Cursor Variables, Oracle PL/SQL Programming

OPEN-FOR statement, native dynamic SQL: 3.2.2. Some Rules and Restrictions, Guide to Oracle8i Features

OPEN_CURSOR function

2.2.3. DBMS_SQL Programs, Oracle Built-in Packages
2.3.2.1. The DBMS_SQL.OPEN_CURSOR function, Oracle Built-in Packages
C.14.14. The OPEN_CURSOR function, Oracle PL/SQL Programming
19.5.6.1. Open and parse, Advanced Oracle PL/SQL Programming with Packages
defining cursor columns and: 2.3.5. Defining Cursor Columns, Oracle Built-in Packages

OPEN_CURSORS parameter: 6.8.1. Maximum Number of Cursors, Oracle PL/SQL Programming

OPS: (see Oracle Parallel Server)

OR REPLACE predicate: 18.3.2. CREATE TYPE and DROP TYPE: Creating and Dropping Types, Oracle PL/SQL Programming

OR bit operation: 9.2.3.3. The UTL_RAW.BIT_OR function, Oracle Built-in Packages

ORA-01652 error messages: 6.2.1.4. Checking for specific errors, Guide to Oracle8i Features

ORA-06502 error messages: 10.5.2. Improved ORA-06502 Error Messages, Guide to Oracle8i Features

ORADBX tool: 25.1. Analyzing Program Performance, Oracle PL/SQL Programming

ORBs (Object Request Brokers)

1.3.8. Calling Java from PL/SQL (Chapter 9, Calling Java from PL/SQL), Guide to Oracle8i Features
1.2.2. Application Development, Oracle Web Applications
9.1. Oracle8i and Java, Guide to Oracle8i Features

ORDER methods: 18.3.6.1. The MAP and ORDER methods, Oracle PL/SQL Programming

OS/2: 2.2.1. The TCP/IP Network, Oracle Web Applications

OUT mode, bind argument: 4.4.3. Argument Modes , Guide to Oracle8i Features

OUT parameters

15.6.2.2. OUT mode, Oracle PL/SQL Programming

22.7.3. Assign Values to All OUT and IN OUT Parameters, Oracle PL/SQL Programming

external procedure mappings: 21.4.1. Datatype Conversion, Oracle PL/SQL Programming

in functions

22.2.1.1. Do not use OUT and IN OUT parameters, Oracle PL/SQL Programming
1.7.5. Structured Code and Other Best Practices, Oracle PL/SQL Programming

OUTLN_PKG package: 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

OVERLAY function: 9.2.3.12. The UTL_RAW.OVERLAY function, Oracle Built-in Packages

OWA_COOKIE package: 2.4.1. The PL/SQL Toolkit, Oracle Web Applications

GET function: 7.3.1.2. Procedures and functions, Oracle Web Applications
GET_ALL procedu: 7.3.1.2. Procedures and functions, Oracle Web Applications
REMOVE procedure: 7.3.1.2. Procedures and functions, Oracle Web Applications
SEND procedure: 7.3.1.2. Procedures and functions, Oracle Web Applications
storing cookies: 7.3.1. OWA_COOKIE: Storing Cookies, Oracle Web Applications

OWA_IMAGE: 2.4.1. The PL/SQL Toolkit, Oracle Web Applications

OWA_OPT_LOCK

7.3.2. OWA_OPT_LOCK: Record Locking, Oracle Web Applications
7.3.2.2. Procedures and functions, Oracle Web Applications
2.4.1. The PL/SQL Toolkit, Oracle Web Applications
CHECKSUM procedure: 7.3.2.2. Procedures and functions, Oracle Web Applications
GET_ROWID function: 7.3.2.2. Procedures and functions, Oracle Web Applications
STORE_VALUES procedure: 7.3.2.2. Procedures and functions, Oracle Web Applications
VERIFY_VALUES function: 7.3.2.2. Procedures and functions, Oracle Web Applications

OWA_PATTERN

2.4.1. The PL/SQL Toolkit, Oracle Web Applications
7.2.2. OWA_PATTERN: Searching and Replacing Text, Oracle Web Applications

OWA_SEC

2.4.1. The PL/SQL Toolkit, Oracle Web Applications
7.4.2. OWA_SEC: Managing Security , Oracle Web Applications

OWA_TEXT

2.4.1. The PL/SQL Toolkit, Oracle Web Applications
7.2.1. OWA_TEXT: Representing Text, Oracle Web Applications
7.2.1.2. Procedures, Oracle Web Applications

OWA_UTIL package

2.4.1. The PL/SQL Toolkit, Oracle Web Applications
7.4.1. OWA_UTIL: Creating Complex HTML Structures, Oracle Web Applications
BIND_VARIABLES procedure: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
CALENDARPRINT procedure: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
CELLSPRINT procedure: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
CHOOSE_DATE procedure: 7.4.1.3. Representing dates, Oracle Web Applications
DATETYPE datatype: 7.4.1.3. Representing dates, Oracle Web Applications
GET_CGI_ENV function: 7.4.1.2. Querying the environment, Oracle Web Applications
GET_OWA_SERVICE_PATH function: 7.4.1.2. Querying the environment, Oracle Web Applications
GET_PROCEDURE function : 7.4.1.1. Debugging, Oracle Web Applications
HTTP_HEADER_CLOSE procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications
IP_ADDRESS datatype: 7.4.1.2. Querying the environment, Oracle Web Applications
LISTPRINT procedure: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
MIME_HEADER procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications
PRINT_CGI_ENV procedure: 7.4.1.2. Querying the environment, Oracle Web Applications
REDIRECT_URL procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications
SHOWPAGE procedure: 7.4.1.1. Debugging, Oracle Web Applications
SHOWSOURCE procedure: 7.4.1.1. Debugging, Oracle Web Applications
SIGNATURE procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications
STATUS_LINE procedure: 7.4.1.4. HTML and HTTP utilities, Oracle Web Applications
TABLEPRINT function: 7.4.1.5. Creating complex HTML structures, Oracle Web Applications
TODATE function: 7.4.1.3. Representing dates, Oracle Web Applications
WHO_CALLED_ME procedure: 7.4.1.1. Debugging, Oracle Web Applications

Object Request Broker (ORB)

1.2.2. Application Development, Oracle Web Applications
1.3.8. Calling Java from PL/SQL (Chapter 9, Calling Java from PL/SQL), Guide to Oracle8i Features
9.1. Oracle8i and Java, Guide to Oracle8i Features

Oracle

how PL/SQL fits in: 1.1. What Is PL/SQL?, Oracle PL/SQL Programming
programming in: (see coding)

Oracle Application Server (OAS)

1.3. Oracle's Solution -- Oracle8i, Oracle Web Applications
4. Oracle Application Server (OAS), Oracle Web Applications

Oracle Audio Video Server: 1.3.8.1. Oracle Lite, Oracle Web Applications

Oracle Call Interface (OCI)

1.3.8.1. Oracle Lite, Oracle Web Applications
7.5.2. DBMS_LOB: Working with Temporary LOBs, Guide to Oracle8i Features
7.6.4. Improved Publish/Subscribe Support, Guide to Oracle8i Features
OCI routines, for external procedures: 21.5. OCI Service Routines, Oracle PL/SQL Programming

Oracle Client Adapter (OCA): 1.3.8.1. Oracle Lite, Oracle Web Applications

Oracle Client Interface (OCI): 1.3.8.1. Oracle Lite, Oracle Web Applications

Oracle Connect String parameter, DAD: 3.2.2.1. DAD parameters, Oracle Web Applications

Oracle Developer/2000 and built-in packages

calling: 1.3.6. Calling Built-in Packaged Code from Oracle Developer/2000 Release 1, Oracle Built-in Packages
exception handling: 1.3.6.2. Handling exceptions in Oracle Developer/2000 Release 1, Oracle Built-in Packages
referencing nonprogram elements: 1.3.6.1. Referencing packaged constants and variables, Oracle Built-in Packages

Oracle Forms

1.2. The Concept of Programming in Oracle Applications, Oracle PL/SQL Programming
1.3.8.1. Oracle Lite, Oracle Web Applications
code of: 1.2. The Concept of Programming in Oracle Applications, Oracle PL/SQL Programming

Oracle Forms applications: 1.3.7. Fine-Grained Access Control (Chapter 8, Deploying Fine-Grained Access Control), Guide to Oracle8i Features

Oracle Lite: 1.3.8.1. Oracle Lite, Oracle Web Applications

Oracle Lock Management (OLM) services: C.7. DBMS_LOCK, Oracle PL/SQL Programming

Oracle Parallel Server (OPS)

job scheduling and: 13.2.3. Miscellaneous Notes, Oracle Built-in Packages
pollling interval and DBMS_ALERT: 3.2.2.4. The DBMS_ALERT.SET_DEFAULTS procedure, Oracle Built-in Packages
testing if running: 10.1.2.15. The DBMS_UTILITY.IS_PARALLEL_SERVER function, Oracle Built-in Packages

Oracle Password parameter, DAD: 3.2.2.1. DAD parameters, Oracle Web Applications

Oracle Procedure Builder: 6.4. PL/SQL Tools, Oracle Web Applications

Oracle Reports: 1.2. The Concept of Programming in Oracle Applications, Oracle PL/SQL Programming

Oracle Server

Version 7.1: (see Release 2.1, PL/SQL)
Version 7.2: (see Release 2.2, PL/SQL)
version information: 10.1.2.19. The DBMS_UTILITY.PORT_STRING function, Oracle Built-in Packages

Oracle Spatial cartridge: 1.3.9. Oracle interMedia, Oracle Web Applications

Oracle Tools, anonymous blocks in: 15.3.3. Anonymous Blocks in the Oracle Tools, Oracle PL/SQL Programming

Oracle User Name parameter, DAD: 3.2.2.1. DAD parameters, Oracle Web Applications

Oracle interMedia

1.3. Oracle's Solution -- Oracle8i, Oracle Web Applications
1.3.9. Oracle interMedia, Oracle Web Applications

Oracle privileges, setting: 9.2.3. Setting Oracle Privileges, Guide to Oracle8i Features

Oracle*Mail: C.8. DBMS_MAIL, Oracle PL/SQL Programming

Oracle, Trusted: About the Contents, Oracle PL/SQL Programming

Oracle/AQ: (see also advanced queuing)

administration on: C.3.2. DBMS_AQADM (PL/SQL 8 Only), Oracle PL/SQL Programming

Oracle/AQ facility: C.3. Oracle AQ, the Advanced Queueing Facility, Oracle PL/SQL Programming

Oracle7: 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure, Oracle Built-in Packages

DBMS_ALERT and: 3.2.3. DBMS_ALERT Examples, Oracle Built-in Packages
DBMS_OUTPUT and: 6.1.1.1. DBMS_OUTPUT programs, Oracle Built-in Packages
ROWID format: 9.1.2. ROWID Concepts, Oracle Built-in Packages
ROWID types: 9. Datatype Packages, Oracle Built-in Packages

Oracle8

AQ and versions of

5. Oracle Advanced Queuing, Oracle Built-in Packages
5.2.3. Authorizing Accounts to Use Oracle AQ, Oracle Built-in Packages

ROWID format: 9.1.2. ROWID Concepts, Oracle Built-in Packages

ROWID types: 9. Datatype Packages, Oracle Built-in Packages

array processing in: 2.5.6.1. Using array processing to insert, Oracle Built-in Packages

datatypes:

DBMS_SQL restrictions: 2.4.1. Some Restrictions, Oracle Built-in Packages
2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure, Oracle Built-in Packages

deferred transaction scheduling with: 17.2.6. Scheduling Propagation (Oracle8 only), Oracle Built-in Packages

messages (pipes) and memory management: 3.1.7.3. The dbpipe utility package, Oracle Built-in Packages

propagation compatibility and versions of: 5.2.2.3. Setting Oracle AQ compatibility, Oracle Built-in Packages

Oracle8 Enterprise Edition, installing AQ and: 5.2.1. Installing the Oracle AQ Facility, Oracle Built-in Packages

Oracle8i:

1.3. Oracle's Solution -- Oracle8i, Oracle Web Applications

autonomous transactions: 1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!), Guide to Oracle8i Features

built-in packages: 1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i), Guide to Oracle8i Features

bulk binds and collects: 1.3.4. Bulk Binds and Collects (Chapter 5, Bulking Up with PL/SQL 8.1), Guide to Oracle8i Features

features: 1.1. What's in Oracle8i Release 8.1?, Guide to Oracle8i Features

fine-grained access control (FGAC): 1.3.7. Fine-Grained Access Control (Chapter 8, Deploying Fine-Grained Access Control), Guide to Oracle8i Features

invoker rights: 1.3.2. Invoker Rights (Chapter 3, Invoker Rights: Your Schema or Mine? ), Guide to Oracle8i Features

and Java

1.2. And Then There's Java, Guide to Oracle8i Features
1.3.8. Calling Java from PL/SQL (Chapter 9, Calling Java from PL/SQL), Guide to Oracle8i Features

native dynamic SQL: 1.3.3. Native Dynamic SQL (Chapter 4, Native Dynamic SQL in Oracle8i), Guide to Oracle8i Features

performance improvments: 1.3.9. Miscellaneous New Features and Performance Improvements (Chapter 10, More Goodies for Oracle8i PL/SQL Developers), Guide to Oracle8i Features

triggers: 1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i), Guide to Oracle8i Features

obj_cur cursor

11.2.1. Cursor Into ALL_OBJECTS, Advanced Oracle PL/SQL Programming with Packages
11.4.1. Opening and Closing the PLVobj Cursor, Advanced Oracle PL/SQL Programming with Packages

object names

parsing: 10.1.2.18. The DBMS_UTILITY.NAME_TOKENIZE procedure, Oracle Built-in Packages
resolving components: 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure, Oracle Built-in Packages
syntax for: 10.2.2.1. Specifying a program name, Oracle Built-in Packages

object numbers

extended ROWID format and: 9.1.2. ROWID Concepts, Oracle Built-in Packages

returning

9.1.3.4. The DBMS_ROWID.ROWID_OBJECT function, Oracle Built-in Packages
10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure, Oracle Built-in Packages

object privileges: 2.5.3.2. Object privileges, Oracle Web Applications

object tables

definition of: 9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4), Oracle Built-in Packages
versus object views: 20.4. Differences Between Object Views and Object Tables, Oracle PL/SQL Programming

object types

18.1.1. Terminology, Oracle PL/SQL Programming

18.1.4.2. Classification , Oracle PL/SQL Programming

constructor methods

18.3.1. About Object Types, Oracle PL/SQL Programming
18.4.1.1. Constructors, Oracle PL/SQL Programming

data dictionary entries: 18.6.1. Data Dictionary, Oracle PL/SQL Programming

defining: 18.2.2. Defining the Object Type Body, Oracle PL/SQL Programming

forward type definitions: 18.3.5.1. Forward type definitions, Oracle PL/SQL Programming

instantiating objects from: 18.2.2.1. PL/SQL usage , Oracle PL/SQL Programming

modifying: 18.6.3. Schema Evolution, Oracle PL/SQL Programming

renaming: 18.6.3. Schema Evolution, Oracle PL/SQL Programming

returning: 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure, Oracle Built-in Packages

syntax for: 18.3. Syntax for Creating Object Types, Oracle PL/SQL Programming

type modifiers: 18.2.3. Adding Complex Data Structures, Oracle PL/SQL Programming

object views

6.1. Triggers on Nested Table View Columns, Guide to Oracle8i Features

20. Object Views, Oracle PL/SQL Programming

INSTEAD OF triggers and: 20.2. INSTEAD OF Triggers, Oracle PL/SQL Programming

REFs and: 20.4.2. Using REFs with Object Views, Oracle PL/SQL Programming

data dictionary entries: 20.7.1. Data Dictionary, Oracle PL/SQL Programming

duplicate OIDs in: 20.4.1.1. Duplicate OIDs in a single view, Oracle PL/SQL Programming

example of: 20.1. Example: Using Object Views, Oracle PL/SQL Programming

object tables versus: 20.4. Differences Between Object Views and Object Tables, Oracle PL/SQL Programming

privileges: 20.7.2. Privileges, Oracle PL/SQL Programming

schema evolution and

20. Object Views, Oracle PL/SQL Programming
20.6. Schema Evolution, Oracle PL/SQL Programming

syntax for: 20.3.1. CREATE VIEW: Creating an Object View, Oracle PL/SQL Programming

object wizards, WebDB: 3.1.2.1. Building database objects, Oracle Web Applications

object-oriented programming

1.3.2. Object-Oriented Design, Advanced Oracle PL/SQL Programming with Packages
18. Object Types, Oracle PL/SQL Programming
18.1.5. Object Programming Themes, Oracle PL/SQL Programming
18.7. Making the Objects Option Work, Oracle PL/SQL Programming
object views and: 20. Object Views, Oracle PL/SQL Programming

object_keeper procedure

1.3.5.1. Examples of encapsulation packages, Oracle Built-in Packages
12.2.4.1. Pinning packages automatically, Oracle Built-in Packages

object_name parameter, ADD_POLICY procedure: 7.3.4. ADD_POLICY: Adding a Policy, Guide to Oracle8i Features

object_schema parameter, ADD_POLICY procedure: 7.3.4. ADD_POLICY: Adding a Policy, Guide to Oracle8i Features

objects

(see also partitioned objects)

5.20. PLVobj: Object Interface, Advanced Oracle PL/SQL Programming with Packages

11. PLVobj: A Packaged Interface to ALL_OBJECTS, Advanced Oracle PL/SQL Programming with Packages

10.1.2.3. The DBMS_UTILITY.ANALYZE_PART_OBJECT procedure (Oracle8 Only), Oracle Built-in Packages

18.1. Introduction to Oracle8 Objects, Oracle PL/SQL Programming

2.5.2. Database Objects, Oracle Web Applications

DBMS_SQL restrictions: 2.4.1. Some Restrictions, Oracle Built-in Packages

LOBs (large objects): 1.4.7.6. Large object support, Oracle PL/SQL Programming

functions for: 13.2. LOB Function Descriptions, Oracle PL/SQL Programming

OIDs (object identifiers): 18.4.2.1. Object identifiers (OIDs), Oracle PL/SQL Programming

REFs: (see REFs)

assigning: 18.4.1.2. Direct assignment, Oracle PL/SQL Programming

binding to cursor: 11.5. Binding Objects to a Dynamic Cursor, Advanced Oracle PL/SQL Programming with Packages

collections as object types: 19.2.1.2. Collection as an attribute of an object type, Oracle PL/SQL Programming

comparing: 18.3.6. Comparing Objects, Oracle PL/SQL Programming

database structure for: 18.2.2.2. DDL usage , Oracle PL/SQL Programming

deleting rows containing: 9.2.5.1. The UTL_REF.DELETE_OBJECT procedure, Oracle Built-in Packages

dependency of: 23.6.1. Displaying Object Dependencies, Oracle PL/SQL Programming

desc command (SQL*Plus): 18.6.2. SQL*Plus "Describe" Command, Oracle PL/SQL Programming

destroying: 18.5.3. Approach 3: Do Everything via Methods, Oracle PL/SQL Programming

dot notation: 18.3.4. Dot Notation, Oracle PL/SQL Programming

dropping

DROP_MASTER_REPOBJECT used for: 15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure, Oracle Built-in Packages

example: 2.5.1. A Generic Drop_Object Procedure, Oracle Built-in Packages

equality of, testing: 18.3.6.2. Equality comparisons, Oracle PL/SQL Programming

examples of

18.1.2. Some Simple Examples, Oracle PL/SQL Programming
18.2. Oracle Objects Example, Oracle PL/SQL Programming

handles for: (see identifiers)

identifiers: (see OIDs)

identifying: 2.5.1. A Generic Drop_Object Procedure, Oracle Built-in Packages

in packages: 16.1.4. Object Persistence, Oracle PL/SQL Programming

index-by tables of: 25.4.8. Use Index-By Tables of Records and Objects, Oracle PL/SQL Programming

inheritance: 18.1.4.3. Inheritance , Oracle PL/SQL Programming

initializing: 18.4.1. The Need to Initialize, Oracle PL/SQL Programming

instantiating: 18.2.2.1. PL/SQL usage , Oracle PL/SQL Programming

locking: 9.2.5.2. The UTL_REF.LOCK_OBJECT procedure, Oracle Built-in Packages

names for, parsing: 2.5.4.3. Constructing the SELECT, Oracle Built-in Packages

numbers for: (see object numbers)

object views: 1.4.7.4. Object views, Oracle PL/SQL Programming

object-oriented model support: 1.4.7.1. Support for an object-oriented model, Oracle PL/SQL Programming

persistence: 1.3.4. Object Persistence, Advanced Oracle PL/SQL Programming with Packages

persistent, modifying: 18.5. Modifying Persistent Objects, Oracle PL/SQL Programming

populating tables with: 11.6. Populating a PL/SQL Table with Object Names, Advanced Oracle PL/SQL Programming with Packages

privileges: 18.3.7. Privileges, Oracle PL/SQL Programming

referencing: 9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4), Oracle Built-in Packages

referring to: 18.4.2. OID, VALUE, REF, and DEREF, Oracle PL/SQL Programming

retrieving

9.2.5.2. The UTL_REF.LOCK_OBJECT procedure, Oracle Built-in Packages
9.2.5.3. The UTL_REF.SELECT_OBJECT procedure, Oracle Built-in Packages

returning value of: 18.4.2.4. DEREF, Oracle PL/SQL Programming

self-reference: (see SELF object)

stored

managing with SQL*Plus: 23.5. Managing Stored Objects with SQL*Plus, Oracle PL/SQL Programming
viewing with SQL: 23.6. Using SQL to Examine Stored Objects, Oracle PL/SQL Programming

synonyms for: 23.2.2. Creating Synonyms for Stored Objects, Oracle PL/SQL Programming

updating: 9.2.5.4. The UTL_REF.UPDATE_OBJECT procedure, Oracle Built-in Packages

views for: 2.5.1. A Generic Drop_Object Procedure, Oracle Built-in Packages

objects and collections, native dynamic SQL: 4.5. Working with Objects and Collections, Guide to Oracle8i Features

off procedure: 11.2.3. DBMS_SYSTEM Examples, Oracle Built-in Packages

offline instantiation: (see master sites, instantiation; snapshots, instantiation)

one-dimensionality of tables: 10.2. Characteristics of PL/SQL Tables, Oracle PL/SQL Programming

one_animal function: 5.7.5. Searching by Correlation Identifier, Oracle Built-in Packages

onestring.spp : 6.2.6.3. Combining locations and filenames, Oracle Built-in Packages

online analytical processing (OLAP): 7. New and Enhanced Built-in Packages in Oracle8i, Guide to Oracle8i Features

online auction (example): 3.2.3.1. The online auction, Oracle Built-in Packages

online help

(see also documentation)

17. PLVhlp: Online Help for PL/SQL Programs, Advanced Oracle PL/SQL Programming with Packages

page size

17.4.2. Setting the Page Size, Advanced Oracle PL/SQL Programming with Packages
17.5.6.4. Maintaining the current page variables, Advanced Oracle PL/SQL Programming with Packages

onlyfair.sql file: 5.3.3. Using the RETURNING Clause with Bulk Operations, Guide to Oracle8i Features

onsale function: 5.7.6. Using Time Delay and Expiration, Oracle Built-in Packages

open function

6.2.6.3. Combining locations and filenames, Oracle Built-in Packages
6.2.6.4. Adding support for paths, Oracle Built-in Packages

openFor program, ndsutil.pkg file: 4.7. NDS Utility Package, Guide to Oracle8i Features

open_and_parse function

2.7.3. Implementing the Window, Advanced Oracle PL/SQL Programming with Packages
5.9.3. Bundled, low-level operations, Advanced Oracle PL/SQL Programming with Packages
19.5.6.1. Open and parse, Advanced Oracle PL/SQL Programming with Packages
2.4.3. Combining Operations, Oracle Built-in Packages

open_objects procedure

5.20.5. Interfacing with the PLVobj cursor, Advanced Oracle PL/SQL Programming with Packages
11.4.1. Opening and Closing the PLVobj Cursor, Advanced Oracle PL/SQL Programming with Packages

opening

PLVobj cursor: 11.4.1. Opening and Closing the PLVobj Cursor, Advanced Oracle PL/SQL Programming with Packages

files: 13.4. Opening and Closing Files, Advanced Oracle PL/SQL Programming with Packages

cursors

6.2.2. Cursor Operations, Oracle PL/SQL Programming
6.5. Opening Cursors, Oracle PL/SQL Programming
6.10.2. Opening Cursors with Parameters, Oracle PL/SQL Programming
6.12.4. Opening Cursor Variables, Oracle PL/SQL Programming

files: 5.11.7. Opening a file, Advanced Oracle PL/SQL Programming with Packages

openprse.sf : 2.4.3. Combining Operations, Oracle Built-in Packages

operating systems

delimiter

5.11.3. Setting the operating system delimiter, Advanced Oracle PL/SQL Programming with Packages
13.2.1. Setting the Operating System Delimiter, Advanced Oracle PL/SQL Programming with Packages

executing commands with DBMS_PIPE: 3.1.7.1. Communicating with the outside world, Oracle Built-in Packages

managing: 5.11. PLVfile: Operating System I/O Manager, Advanced Oracle PL/SQL Programming with Packages

operating sytem files: C.17. UTL_FILE, Oracle PL/SQL Programming

returning name of: 10.1.2.19. The DBMS_UTILITY.PORT_STRING function, Oracle Built-in Packages

operators, REFs as: 18.4.2.2. REFs, Oracle PL/SQL Programming

optimistic locking: 7.3.2. OWA_OPT_LOCK: Record Locking, Oracle Web Applications

optimizing foreign key lookups: 10.9.5. Optimizing Foreign Key Lookups with PL/SQL Tables, Oracle PL/SQL Programming

optional parameters: 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure , Oracle Built-in Packages

oracle.sql.STRUCT class: 9.9.2. Passing Objects to Java, Guide to Oracle8i Features

order, VARRAY elements: 19.4.1.4. VARRAY integration, Oracle PL/SQL Programming

order of package elements: 2.2.1. Choosing the Order of Elements, Advanced Oracle PL/SQL Programming with Packages

out_of_bounds exception: 5.18.1. Package exceptions, Advanced Oracle PL/SQL Programming with Packages

outer tables: 19.1. Types of Collections, Oracle PL/SQL Programming

output

(see also I/O)
from p package: 7.4. Controlling Output from p, Advanced Oracle PL/SQL Programming with Packages

output generation: 6.1. DBMS_OUTPUT: Displaying Output, Oracle Built-in Packages

disabling output: 6.1.2.2. The DBMS_OUTPUT.DISABLE procedure, Oracle Built-in Packages

enabling output

6.1.2.1. The DBMS_OUTPUT.ENABLE procedure, Oracle Built-in Packages
6.1.5. Tips on Using DBMS_OUTPUT, Oracle Built-in Packages

enabling/disabling with SQL*: 6.1.2.2. The DBMS_OUTPUT.DISABLE procedure, Oracle Built-in Packages

reading

multiple lines: 6.1.4.2. The DBMS_OUTPUT.GET_LINES procedure, Oracle Built-in Packages

one line: 6.1.4.1. The DBMS_OUTPUT.GET_LINE procedure, Oracle Built-in Packages

writing

data: 6.1.3.1. The DBMS_OUTPUT.PUT procedure, Oracle Built-in Packages

data with newline marker: 6.1.3.2. The DBMS_OUTPUT.PUT_LINE procedure, Oracle Built-in Packages

newline markers: 6.1.3.3. The DBMS_OUTPUT.NEW_LINE procedure, Oracle Built-in Packages

output prefix: 7.3. The Output Prefix , Advanced Oracle PL/SQL Programming with Packages

overhead, CPU

(see also performance)
operation: 14.4.2. Calculating Overhead of an Action, Advanced Oracle PL/SQL Programming with Packages

overlap function

5.29.2. Setting the overlap, Advanced Oracle PL/SQL Programming with Packages
15.2.2. Setting the Code Overlap, Advanced Oracle PL/SQL Programming with Packages

overlap, code: 15.2.2. Setting the Code Overlap, Advanced Oracle PL/SQL Programming with Packages

overloading

2.8. Overloading for Smart Packages, Advanced Oracle PL/SQL Programming with Packages
2.9.1. Implementing Overloading with Private Programs, Advanced Oracle PL/SQL Programming with Packages
describing parameters and: 10.2.2.3. How overloading is handled, Oracle Built-in Packages
in PLVgen package: 16.4.4. Overloading in PLVgen, Advanced Oracle PL/SQL Programming with Packages
l procedure: 5.2.4. The overloadings of the l procedure, Advanced Oracle PL/SQL Programming with Packages
PL/SQL: 6.1.5. Overloading, Oracle Web Applications

overloaded modules

18.1.4.4. Polymorphism , Oracle PL/SQL Programming
1.6.6. Module overloading, Oracle PL/SQL Programming
15.8. Module Overloading, Oracle PL/SQL Programming
restrictions on: 15.8.4. Restrictions on Overloading, Oracle PL/SQL Programming

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