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

Index: O

object names

parsing : 10.1.2.18. The DBMS_UTILITY.NAME_TOKENIZE procedure

resolving components : 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure

syntax for : 10.2.2.1. Specifying a program name

object numbers

extended ROWID format and : 9.1.2. ROWID Concepts

returning

9.1.3.4. The DBMS_ROWID.ROWID_OBJECT function

10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure

object tables, definition : 9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4)

object types, returning : 10.1.2.17. The DBMS_UTILITY.NAME_RESOLVE procedure

object_keeper procedure

1.3.5.1. Examples of encapsulation packages

12.2.4.1. Pinning packages automatically

objects

(see also partitioned objects)

10.1.2.3. The DBMS_UTILITY.ANALYZE_PART_OBJECT procedure (Oracle8 Only)

DBMS_SQL restrictions : 2.4.1. Some Restrictions

deleting rows containing : 9.2.5.1. The UTL_REF.DELETE_OBJECT procedure

dropping

DROP_MASTER_REPOBJECT used for : 15.3.3.3. The DBMS_REPCAT.DROP_MASTER_REPOBJECT procedure

example : 2.5.1. A Generic Drop_Object Procedure

identifying : 2.5.1. A Generic Drop_Object Procedure

locking : 9.2.5.2. The UTL_REF.LOCK_OBJECT procedure

names for, parsing : 2.5.4.3. Constructing the SELECT

numbers for : (see object numbers)

referencing : 9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4)

retrieving

9.2.5.2. The UTL_REF.LOCK_OBJECT procedure

9.2.5.3. The UTL_REF.SELECT_OBJECT procedure

updating : 9.2.5.4. The UTL_REF.UPDATE_OBJECT procedure

views for : 2.5.1. A Generic Drop_Object Procedure

off procedure : 11.2.3. DBMS_SYSTEM Examples

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

one_animal function : 5.7.5. Searching by Correlation Identifier

onestring.spp : 6.2.6.3. Combining locations and filenames

online auction (example) : 3.2.3.1. The online auction

onsale function : 5.7.6. Using Time Delay and Expiration

open function

6.2.6.3. Combining locations and filenames

6.2.6.4. Adding support for paths

open_and_parse function : 2.4.3. Combining Operations

OPEN_CURSOR function

2.2.3. DBMS_SQL Programs

2.3.2.1. The DBMS_SQL.OPEN_CURSOR function

defining cursor columns and : 2.3.5. Defining Cursor Columns

openprse.sf : 2.4.3. Combining Operations

operating systems

executing commands with DBMS_PIPE : 3.1.7.1. Communicating with the outside world

returning name of : 10.1.2.19. The DBMS_UTILITY.PORT_STRING function

OPS : (see Oracle Parallel Server)

optional parameters : 2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure

OR bit operation : 9.2.3.3. The UTL_RAW.BIT_OR function

Oracle Developer/2000 and built-in packages

calling : 1.3.6. Calling Built-in Packaged Code from Oracle Developer/2000 Release 1

exception handling : 1.3.6.2. Handling exceptions in Oracle Developer/2000 Release 1

referencing nonprogram elements : 1.3.6.1. Referencing packaged constants and variables

Oracle Parallel Server (OPS)

job scheduling and : 13.2.3. Miscellaneous Notes

pollling interval and DBMS_ALERT : 3.2.2.4. The DBMS_ALERT.SET_DEFAULTS procedure

testing if running : 10.1.2.15. The DBMS_UTILITY.IS_PARALLEL_SERVER function

Oracle Server, version information : 10.1.2.19. The DBMS_UTILITY.PORT_STRING function

Oracle7 : 15.3.4.1. The DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT procedure

DBMS_ALERT and : 3.2.3. DBMS_ALERT Examples

DBMS_OUTPUT and : 6.1.1.1. DBMS_OUTPUT programs

ROWID format : 9.1.2. ROWID Concepts

ROWID types : 9. Datatype Packages

Oracle8

AQ and versions of

5. Oracle Advanced Queuing

5.2.3. Authorizing Accounts to Use Oracle AQ

array processing in : 2.5.6.1. Using array processing to insert

datatypes : 2.3.11.1. The DBMS_SQL.DESCRIBE_COLUMNS procedure

DBMS_SQL restrictions : 2.4.1. Some Restrictions

deferred transaction scheduling with : 17.2.6. Scheduling Propagation (Oracle8 only)

messages (pipes) and memory management : 3.1.7.3. The dbpipe utility package

propagation compatibility and versions of : 5.2.2.3. Setting Oracle AQ compatibility

ROWID format : 9.1.2. ROWID Concepts

ROWID types : 9. Datatype Packages

Oracle8 Enterprise Edition, installing AQ and : 5.2.1. Installing the Oracle AQ Facility

output generation : 6.1. DBMS_OUTPUT: Displaying Output

disabling output : 6.1.2.2. The DBMS_OUTPUT.DISABLE procedure

enabling output

6.1.2.1. The DBMS_OUTPUT.ENABLE procedure

6.1.5. Tips on Using DBMS_OUTPUT

enabling/disabling with SQL* : 6.1.2.2. The DBMS_OUTPUT.DISABLE procedure

reading

multiple lines : 6.1.4.2. The DBMS_OUTPUT.GET_LINES procedure

one line : 6.1.4.1. The DBMS_OUTPUT.GET_LINE procedure

writing

data : 6.1.3.1. The DBMS_OUTPUT.PUT procedure

data with newline marker : 6.1.3.2. The DBMS_OUTPUT.PUT_LINE procedure

newline markers : 6.1.3.3. The DBMS_OUTPUT.NEW_LINE procedure

OVERLAY function : 9.2.3.12. The UTL_RAW.OVERLAY function

overloading, describing parameters and : 10.2.2.3. How overloading is handled

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