start page | rating of books | rating of authors | reviews | copyrights

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

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

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