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
- 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
- registering
: 7.2.5. The DBMS_APPLICATION_INFO.SET_MODULE procedure
- 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
- ADD_<conflicttype>_RESOLUTION procedure
- ADD_DEFAULT_DEST procedure
- ADD_DELETE_RESOLUTION procedure
: 16.5.1.1. The DBMS_REPCAT.ADD_<conflicttype>_RESOLUTION
- ADD_GROUPED_COLUMN procedure
- ADD_MASTER_DATABASE procedure
- ADD_PRIORITY_<datatype> procedure
- ADD_SITE_PRIORITY_SITE procedure
- 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
- ADD_UPDATE_RESOLUTION procedure : 16.5.1.1. The DBMS_REPCAT.ADD_<conflicttype>_RESOLUTION
- (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
- 15. Advanced Replication
- 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
- remote destinations and : 17.1.1. About Remote Destinations
- 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
- granting privileges
: 15.1.2.1. The DBMS_REPCAT_AUTH.GRANT_SURROGATE_REPCAT procedure
- (see also replicated and replication headings)
- ADVISE_COMMIT procedure
- ADVISE_NOTHING procedure
- ADVISE_ROLLBACK procedure
- agents
- (see also consumers; producers)
- 5.1.5. A Glossary of Terms
- object type for : 5.3.4. Agents Object Type
- 5.1.5. A Glossary of Terms
- (see also consumers; producers)
- 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
- names for : 3.2.2.1. The DBMS_ALERT.REGISTER procedure
- locking and
: 3.2.2.5. The DBMS_ALERT.SIGNAL procedure
- ALL_OBJECTS view, identifying objects and
: 2.5.1. A Generic Drop_Object Procedure
- ALLOCATE_UNIQUE procedure
- allocating cursors
: (see cursors, opening; cursors, reusing)
- ALTER_COMPILE procedure : 10.3.2. Compiling PL/SQL Objects
- ALTER_MASTER_PROPAGATION procedure
- ALTER_COMPILE procedure : 10.3.2. Compiling PL/SQL Objects
- ALTER_MASTER_REPOBJECT procedure
- ALTER_PRIORITY procedure
- ALTER_PRIORITY_<datatype> procedure
- ALTER_QUEUE procedure
- ALTER_SITE_PRIORITY procedure
- ALTER_SITE_PRIORITY_SITE procedure
- ALTER_SNAPSHOT_PROPAGATION procedure
- ALTER_TABLE_NOT_REFERENCEABLE procedure
- ALTER_TABLE_REFERENCEABLE procedure
- alternate indexes, hashing and (example)
: 10.1.2.12. The DBMS_UTILITY.GET_HASH_VALUE function
- ANALYZE_DATABASE procedure
- ANALYZE_OBJECT procedure
- ANALYZE_PART_OBJECT procedure
- 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
- ANY parameters : 9.2.4. UTL_REF: Referencing Objects (Oracle8.0.4)
- apinex2.sql
: 7.2.6.1. Example
- apinex3.sql : 7.3.9. Tracking Long-Running Processes
- APPEND procedure
- apinex3.sql : 7.3.9. Tracking Long-Running Processes
- AQ (Advanced Queuing) : 5. Oracle Advanced Queuing
- components of
: 5.1.6. Components of Oracle AQ
- constants
- 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
- data structures : 5.3. Oracle AQ Nonprogram Elements
- 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
- encapsulating (example) : 5.7.1. Improving AQ Ease of Use
- 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
- encapsulating : 5.7.1. Improving AQ Ease of Use
- browsing
: 5.7.4. Browsing a Queue's Contents
- exception queues
: (see exception queues)
- 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
- glossary of terms : 5.1.5. A Glossary of Terms
- pipes versus
: 3.1.2.3. Pipe communications logic
- privileges
- 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
- recipient list : 5.3.6. Message Properties Record Type
- data dictionary
: 5.1.8. Data Dictionary Views
- per queue table : 5.6.1.2. The queue table view
- data dictionary
: 5.1.8. Data Dictionary Views
- components of
: 5.1.6. Components of Oracle AQ
- 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
- 1.3.5.1. Examples of encapsulation packages
- (see also specific program names)
- aq.spp
- 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
- AQ_USER_ROLE : 5.2.3. Authorizing Accounts to Use Oracle AQ
- (see also specific program names)
- 5.7.4. Browsing a Queue's Contents
- (see also specific program names)
- aqbrowse.sp
- aqbrowse.tst
: 5.7.4. Browsing a Queue's Contents
- aqcorrid.spp
- 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
- aqcorrid.tst : 5.7.5. Searching by Correlation Identifier
- (see also specific program names)
- 5.7.4.1. A template for a show_queue procedure
- (see also specific program names)
- 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
- (see also specific program names)
- (see also
- 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
- aqstk2.spp : 5.7.3. Building a Stack with AQ Using Sequence Deviation
- (see also parameters)
- 10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure
- RPC arguments : (see RPCs, arguments)
- 10.2.1.3. The DBMS_DESCRIBE.DESCRIBE_PROCEDURE procedure
- (see also parameters)
- arrayemp.sp
: 2.3.8.1. The DBMS_SQL.COLUMN_VALUE procedure
- arrays
- binding variables
- 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
- DBMS_SQL used for processing : 2.5.6. Array Processing with DBMS_SQL
- fetching rows
: 2.5.6.4. Using array processing to fetch
- index-by tables and
- 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
- Oracle8 and : 2.5.6.1. Using array processing to insert
- 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
- arrayupd.tst : 2.5.6.3. Using array processing to update
- auction package
- (see also specific program names)
- 3.2.3.3. Auction system requirements
- (see also specific program names)
- 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
- auction1.sql : 3.2.3.5. The auction package
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.