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

ABORTED_REQUEST_THRESHOLD procedure
  12.2.1. Getting Started with DBMS_SHARED_POOL
  12.2.3.2. The DBMS_SHARED_POOL.ABORTED_REQUEST_THRESHOLD procedure
absolute file numbers, returning : 9.1.3.7. The DBMS_ROWID.ROWID_TO_ABSOLUTE_FNO function
action names
  registering : 7.2.5. The DBMS_APPLICATION_INFO.SET_MODULE procedure
  returning : 7.2.2. The DBMS_APPLICATION_INFO.READ_MODULE procedure
action procedure
  7.3.1. About the register_app Package
  7.3.2. The action Procedure
ad-hoc query generation, Method 4 dynamic SQL used for : 2.5.4. Displaying Table Contents with Method 4 Dynamic SQL
ADD procedure
  14.2.1. Getting Started with DBMS_REFRESH
  14.2.3.1. The DBMS_REFRESH.ADD procedure
ADD_<conflicttype>_RESOLUTION procedure
  16.1.1. DBMS_REPCAT Programs
  16.5.1.1. The DBMS_REPCAT.ADD_<conflicttype>_RESOLUTION
ADD_DEFAULT_DEST procedure
  17.2.1.1. DBMS_DEFER_SYS programs
  17.2.2.1. The DBMS_DEFER.SYS.ADD_DEFAULT_DEST procedure
ADD_DELETE_RESOLUTION procedure : 16.5.1.1. The DBMS_REPCAT.ADD_<conflicttype>_RESOLUTION
ADD_GROUPED_COLUMN procedure
  16.1.1. DBMS_REPCAT Programs
  16.2.3.1. The DBMS_REPCAT.ADD_GROUPED_COLUMN procedure
ADD_MASTER_DATABASE procedure
  15.3.1.1. DBMS_REPCAT programs
  15.3.5.1. The DBMS_REPCAT.ADD_MASTER_DATABASE procedure
ADD_PRIORITY_<datatype> procedure
  16.1.1. DBMS_REPCAT Programs
  16.3.3.1. The DBMS_REPCAT.ADD_PRIORITY_<datatype> procedure
ADD_SITE_PRIORITY_SITE procedure
  16.1.1. DBMS_REPCAT Programs
  16.4.3.1. The DBMS_REPCAT.ADD_SITE_PRIORITY_SITE procedure
ADD_SUBSCRIBER procedure
  5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)
  5.5.3.1. The DBMS_AQADM.ADD_SUBSCRIBER procedure
ADD_UNIQUE_RESOLUTION procedure : 16.5.1.1. The DBMS_REPCAT.ADD_<conflicttype>_RESOLUTION
ADD_UPDATE_RESOLUTION procedure : 16.5.1.1. The DBMS_REPCAT.ADD_<conflicttype>_RESOLUTION
addname procedure : 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function
administrator accounts : (see advanced replication, administrator accounts)
administrator role (AQ) : 5.2.3. Authorizing Accounts to Use Oracle AQ
Advanced Queuing : (see AQ)
advanced replication
  (see also replicated and replication headings)
  15. Advanced Replication
  account creation : 15.1. DBMS_REPCAT_AUTH: Setting Up Administrative Accounts
  administrator accounts : 15.2. DBMS_REPCAT_ADMIN: Setting Up More Administrator Accounts
    granting privileges : 15.2.2.1. The DBMS_REPCAT_ADMIN.GRANT_ADMIN_REPGROUP procedure
    revoking privileges
      15.2.2.2. The DBMS_REPCAT_ADMIN.REVOKE_ADMIN_REPGROUP procedure
      15.2.2.4. The DBMS_REPCAT_ADMIN.REVOKE_ADMIN_ANY_REPGROUP procedure
  propagator accounts : 15.1.3. Granting and Revoking Propagator Accounts (Oracle8)
  remote destinations and : 17.1.1. About Remote Destinations
  user accounts : 15.1.2. Granting and Revoking Surrogate SYS Accounts
    granting privileges : 15.1.2.1. The DBMS_REPCAT_AUTH.GRANT_SURROGATE_REPCAT procedure
    revoking privileges : 15.1.2.2. The DBMS_REPCAT_AUTH.REVOKE_SURROGATE_REPCAT procedure
ADVISE_COMMIT procedure
  4.2.1.1. DBMS_TRANSACTION programs
  4.2.2.1. The DBMS_TRANSACTION.ADVISE_ROLLBACK, and ADVISE_COMMIT procedures
ADVISE_NOTHING procedure
  4.2.1.1. DBMS_TRANSACTION programs
  4.2.2.1. The DBMS_TRANSACTION.ADVISE_ROLLBACK, and ADVISE_COMMIT procedures
ADVISE_ROLLBACK procedure
  4.2.1.1. DBMS_TRANSACTION programs
  4.2.2.1. The DBMS_TRANSACTION.ADVISE_ROLLBACK, and ADVISE_COMMIT procedures
agents
  (see also consumers; producers)
  5.1.5. A Glossary of Terms
  object type for : 5.3.4. Agents Object Type
alerts : 3.2. DBMS_ALERT: Broadcasting Alerts to Users
  locking and : 3.2.2.5. The DBMS_ALERT.SIGNAL procedure
  names for : 3.2.2.1. The DBMS_ALERT.REGISTER procedure
  registering : 3.2.2.1. The DBMS_ALERT.REGISTER procedure
  removing : 3.2.2.2. The DBMS_ALERT.REMOVE procedure
  setting defaults : 3.2.2.4. The DBMS_ALERT.SET_DEFAULTS procedure
  signaling : 3.2.2.5. The DBMS_ALERT.SIGNAL procedure
  transactional behavior : 3.2.2.5. The DBMS_ALERT.SIGNAL procedure
  waiting for : 3.2.2.6. The DBMS_ALERT.WAITANY procedure
ALL_OBJECTS view, identifying objects and : 2.5.1. A Generic Drop_Object Procedure
ALLOCATE_UNIQUE procedure
  4.1.1.1. DBMS_LOCK programs
  4.1.2.1. The DBMS_LOCK.ALLOCATE_UNIQUE procedure
allocating cursors : (see cursors, opening; cursors, reusing)
ALTER_COMPILE procedure : 10.3.2. Compiling PL/SQL Objects
ALTER_MASTER_PROPAGATION procedure
  15.3.1.1. DBMS_REPCAT programs
  15.3.8.2. The DBMS_REPCAT.ALTER_MASTER_PROPAGATION procedure
ALTER_MASTER_REPOBJECT procedure
  15.3.1.1. DBMS_REPCAT programs
  15.3.3.5. The DBMS_REPCAT.ALTER_MASTER_REPOBJECT procedure
ALTER_PRIORITY procedure
  16.1.1. DBMS_REPCAT Programs
  16.3.3.2. The DBMS_REPCAT.ALTER_PRIORITY procedure
ALTER_PRIORITY_<datatype> procedure
  16.1.1. DBMS_REPCAT Programs
  16.3.3.3. The DBMS_REPCAT.ALTER_PRIORITY_<datatype> procedure
ALTER_QUEUE procedure
  5.5. DBMS_AQADM: Performing AQ Administrative Tasks (Oracle8 only)
  5.5.2.3. The DBMS_AQADM.ALTER_QUEUE procedure
ALTER_SITE_PRIORITY procedure
  16.1.1. DBMS_REPCAT Programs
  16.4.3.3. The DBMS_REPCAT.ALTER_SITE_PRIORITY procedure
ALTER_SITE_PRIORITY_SITE procedure
  16.1.1. DBMS_REPCAT Programs
  16.4.3.4. The DBMS_REPCAT.ALTER_SITE_PRIORITY_SITE
ALTER_SNAPSHOT_PROPAGATION procedure
  14.4.1.1. DBMS_REPCAT programs
  14.4.4. Altering a Snapshot Replication Group's Propagation Mode
ALTER_TABLE_NOT_REFERENCEABLE procedure
  10.3.1.1. DBMS_DDL programs
  10.3.4.2. The DBMS_DDL.ALTER_TABLE_NOT_REFERENCEABLE procedure (Oracle8 only)
ALTER_TABLE_REFERENCEABLE procedure
  10.3.1.1. DBMS_DDL programs
  10.3.4.1. The DBMS_DDL. (Oracle8 only)
alternate indexes, hashing and (example) : 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function
ANALYZE_DATABASE procedure
  10.1.1. Getting Started with DBMS_UTILITY
  10.1.2.1. The DBMS_UTILITY.ANALYZE_DATABASE procedure
ANALYZE_OBJECT procedure
  10.3.1.1. DBMS_DDL programs
  10.3.3.1. The DBMS_DDL.ANALYZE_OBJECT procedure
ANALYZE_PART_OBJECT procedure
  10.1.1. Getting Started with DBMS_UTILITY
  10.1.2.3. The DBMS_UTILITY.ANALYZE_PART_OBJECT procedure (Oracle8 Only)
ANALYZE_SCHEMA procedure
  10.1.1. Getting Started with DBMS_UTILITY
  10.1.2.2. The DBMS_UTILITY.ANALYZE_SCHEMA procedure
AND bit operation : 9.2.3.1. The UTL_RAW.BIT_AND function
ANY parameters : 9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4)
ANY_CHAR_ARG procedure : 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure
ANY_CLOB_ARG procedure : 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure
ANY_VARCHAR2_ARG procedure : 17.3.3.1. The DBMS_DEFER.<datatype>_ARG procedure
apinex1.sql
  7.2.3.2. Example
  7.2.4.2. Example
  7.2.5.2. Example
apinex2.sql : 7.2.6.1. Example
apinex3.sql : 7.3.9. Tracking Long-Running Processes
APPEND procedure
  8.1.1. DBMS_LOB Programs
  8.3.3.1. The DBMS_LOB.APPEND procedure
AQ (Advanced Queuing) : 5. Oracle Advanced Queuing
  components of : 5.1.6. Components of Oracle AQ
  constants
    5.3.1.1. Administrative tasks
    5.3.1.2. Operational tasks
  creating : 5.2.1. Installing the Oracle AQ Facility
  data structures : 5.3. Oracle AQ Nonprogram Elements
  data typing and : 5.1.1. General Features
  database objects
    5.6. Oracle AQ Database Objects
    5.6.1. Objects Per Queue Table
    data dictionary : 5.6.2. Data Dictionary Objects
  dequeuing : (see dequeuing)
  encapsulating (example) : 5.7.1. Improving AQ Ease of Use
  enqueuing : (see enqueuing)
  example scripts (by Oracle) : 5.7. Oracle AQ Examples
  examples : 5.7. Oracle AQ Examples
    browsing : 5.7.4. Browsing a Queue's Contents
    encapsulating : 5.7.1. Improving AQ Ease of Use
    message groups : 5.7.7. Working with Message Groups
    multiple consumers : 5.7.8. Working with Multiple Consumers
    prioritized queues : 5.7.2. Working with Prioritized Queues
    searching by correlation identifier : 5.7.5. Searching by Correlation Identifier
    time delay and expiration : 5.7.6. Using Time Delay and Expiration
  exception queues : (see exception queues)
  exceptions
    5.1.3. Dequeue Features
    5.3.9. Oracle AQ Exceptions
  features : 5.1.1. General Features
  glossary of terms : 5.1.5. A Glossary of Terms
  installing : 5.2.1. Installing the Oracle AQ Facility
  object names : 5.3.2. Object Names
  Oracle8 versions and
    5. Oracle Advanced Queuing
    5.2.2.3. Setting Oracle AQ compatibility
  pipes versus : 3.1.2.3. Pipe communications logic
  privileges
    5.2.1. Installing the Oracle AQ Facility
    5.2.3. Authorizing Accounts to Use Oracle AQ
  propagation : (see propagating messages)
  recipient list : 5.3.6. Message Properties Record Type
  roles : 5.2.3. Authorizing Accounts to Use Oracle AQ
  stacks (example) : 5.7.3. Building a Stack with AQ Using Sequence Deviation
  tables and : 5.1.1. General Features
  views for
    data dictionary : 5.1.8. Data Dictionary Views
    per queue table : 5.6.1.2. The queue table view
aq package
  (see also specific program names)
  1.3.5.1. Examples of encapsulation packages
  5.3.2. Object Names
  5.4.1.2. Examples
  5.7.1. Improving AQ Ease of Use
aq.spp
  5.3.2. Object Names
  5.7.1. Improving AQ Ease of Use
AQ_ADMINISTRATOR_ROLE : 5.2.3. Authorizing Accounts to Use Oracle AQ
AQ_USER_ROLE : 5.2.3. Authorizing Accounts to Use Oracle AQ
aqadmset.sql file : 5.2.3. Authorizing Accounts to Use Oracle AQ
aqbrowse package
  (see also specific program names)
  5.7.4. Browsing a Queue's Contents
aqbrowse.sp
  5.7.1. Improving AQ Ease of Use
  5.7.4. Browsing a Queue's Contents
aqbrowse.tst : 5.7.4. Browsing a Queue's Contents
aqcorrid.spp
  5.7.4.1. A template for a show_queue procedure
  5.7.5. Searching by Correlation Identifier
aqcorrid.tst : 5.7.5. Searching by Correlation Identifier
aqcorrid.tst : 5.7.5. Searching by Correlation Identifier
aqcref.sql : 5.5.2.2. The DBMS_AQADM.START_QUEUE procedure
aqcremq.sql : 5.5.3.3. The DBMS_AQADM.QUEUE_SUBSCRIBERS procedure
aqcrepq.sql : 5.5.2.2. The DBMS_AQADM.START_QUEUE procedure
aqcreq.sql : 5.5.2.2. The DBMS_AQADM.START_QUEUE procedure
aqdemo*.sql scripts : 5.7. Oracle AQ Examples
aqdeq1.sql : 5.4.2.2. Examples
aqdeq2.sql : 5.4.2.2. Examples
aqdeq2.sql : 5.4.2.2. Examples
aqdeq3.sql : 5.4.2.4. Dequeue order
aqdeq4.sql : 5.4.2.4. Dequeue order
aqenq1.sql : 5.4.1.2. Examples
aqenq2.sql : 5.4.1.2. Examples
aqfor.sql file : 5.2.3. Authorizing Accounts to Use Oracle AQ
aqgroup.spp : 5.7.7.2. Dequeuing messages when part of a group
aqmult.ins : 5.7.8.1. Using the subscriber list
aqmult1.spp : 5.7.8.1. Using the subscriber list
aqmult2.ins : 5.7.8.1. Using the subscriber list
aqmult2.spp : 5.7.8.1. Using the subscriber list
aqmult2.tst : 5.7.8.1. Using the subscriber list
aqmult3.spp : 5.7.8.2. Overriding with a recipient list
aqmult3.tst : 5.7.8.2. Overriding with a recipient list
aqshomsg.sql : 5.4.1.2. Examples
aqshowq package
  (see also specific program names)
  5.7.4.1. A template for a show_queue procedure
aqshowq.sp : 5.7.4.1. A template for a show_queue procedure
aqstk package
  (see also
  (see also specific program names)
  5.7.3. Building a Stack with AQ Using Sequence Deviation
aqstk.spp : 5.7.3. Building a Stack with AQ Using Sequence Deviation
aqstk2.spp : 5.7.3. Building a Stack with AQ Using Sequence Deviation
aqtiming.ins : 5.7.6. Using Time Delay and Expiration
aqtiming.spp : 5.7.6. Using Time Delay and Expiration
aqtiming.tst : 5.7.6. Using Time Delay and Expiration
arg function : 10.2.3.1. Features of the psdesc package
args procedure : 10.2.3.1. Features of the psdesc package
arguments
  (see also parameters)
  10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure
  RPC arguments : (see RPCs, arguments)
arrayemp.sp : 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure
arrays
  binding variables
    2.3.4. Binding Values into Dynamic SQL
    2.3.4.1. The DBMS_SQL.BIND_VARIABLE procedure
  copying index tables : 2.5.6.5. Using array processing in dynamic PL/SQL
  DBMS_SQL used for processing : 2.5.6. Array Processing with DBMS_SQL
  defining columns : 2.3.5.2. The DBMS_SQL.DEFINE_ARRAY procedure
  deleting rows
    2.5.6.2. Using array processing to delete
    2.5.7.2. RETURNING from a multiple-row delete
  fetching rows : 2.5.6.4. Using array processing to fetch
  index-by tables and
    2.2.6. DBMS_SQL Nonprogram Elements
    2.5.6. Array Processing with DBMS_SQL
  inserting rows : 2.5.6.1. Using array processing to insert
  Oracle8 and : 2.5.6.1. Using array processing to insert
  performance of fetching : 2.5.6.4. Using array processing to fetch
  updating rows : 2.5.6.3. Using array processing to update
  variable arrays : 2.4.1. Some Restrictions
arrayupd.spp : 2.5.6.3. Using array processing to update
arrayupd.tst : 2.5.6.3. Using array processing to update
as.spp : 5.3.2. Object Names
assign procedure
  2.5.5. Indirect Referencing in PL/SQL
  2.5.5.1. Assigning a value
auction package
  (see also specific program names)
  3.2.3.3. Auction system requirements
auction.ddl : 3.2.3.2. The auction schema
auction1.sql : 3.2.3.5. The auction package
authority : (see privileges)
automatic recovery : 4.2.6.2. The DBMS_TRANSACTION.PURGE_LOST_DB_ENTRY procedure

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.