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

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