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 | 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


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
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