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