Index Symbols | A | B | C | D | E | F | G | H | I | J | L | M | N | O | P | Q | R | S | T | U | V | W | X Index: A access control, system level : 7.6.2. System-Level Access Control ACID principle : 2.1. Transaction Management in PL/SQL ACTIVE_INSTANCES function, DBMS_UTILITY package : 7.7.2. ACTIVE_INSTANCES: Returning a List of Active Instances ADD_POLICY procedure, DBMS_RLS package : 7.3.4. ADD_POLICY: Adding a Policy ADD_SUBSCRIBER procedure, DBMS_AQADM package : 7.6.4.1. Rule-based subscribers admin_option parameter, GRANT_SYSTEM_PRIVILEGE procedure : 7.6.2.1. GRANT_SYSTEM_PRIVILEGE: Granting system-level privileges ADMINISTER DATABASE TRIGGER system privilege : 6.2. Database-Level Event Triggers Advanced Queuing (AQ) facility 1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i) 6. New Trigger Features in Oracle8i 6.2.1.2. Tracking logins to the database 7.6. New DBMS_AQ and DBMS_AQADM Features AFTER context, triggers : 6.2. Database-Level Event Triggers AFTER STARTUP triggers : 6.2. Database-Level Event Triggers aliases, table names : 7.3.4. ADD_POLICY: Adding a Policy ALL option, GRANT_QUEUE_PRIVILEGE procedure : 7.6.3.2. REVOKE_QUEUE_PRIVILEGE: Revoking queue-level privileges ALL_CONTEXT data dictionary view : 8.4.3. Context Data Dictionary Views ALL_ERRORS data dictionary view : 9.6.2. Examining Loaded Java Elements ALL_OBJECTS data dictionary view : 9.6.2. Examining Loaded Java Elements ALL_POLICIES data dictionary view : 8.4.3. Context Data Dictionary Views ALTER command 1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i) 6. New Trigger Features in Oracle8i 6.3. Schema-Level Event Triggers 7.2.3. Controlling Trace File Contents ALTER JAVA statement : 9.1. Oracle8i and Java anonymous blocks 1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!) 10.5. Miscellaneous and Minor Improvements APIs (application programming interfaces) 7.1. DBMS_PROFILER: Providing Code Profiling

1.3.8. Calling Java from PL/SQL (Chapter 9, Calling Java from PL/SQL) 7.2. DBMS_TRACE: Providing a PL/SQL Trace Facility aq.sql file : 6.2.1.2. Tracking logins to the database AQ_USER_ROLE : 7.6.2. System-Level Access Control aqlisten.sql file : 7.6.4.2. LISTEN: Listening for messages AUTHID CURRENT_USER clause 1.3.2. Invoker Rights (Chapter 3, Invoker Rights: Your Schema or Mine? ) 3.2.1. Invoker Rights Syntax AUTHID DEFINER clause : 3.2.2. Some Rules and Restrictions autonomous blocks, definition : 2.4. Rules and Restrictions autonomous transactions
6.2. Database-Level Event Triggers

1.1. What's in Oracle8i Release 8.1? 1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!) autonomous logging mechanism example : 2.5.1. Building an Autonomous Logging Mechanism database triggers example : 2.5.2. Using Autonomous Transactions in a Database Trigger definition
: 2.2. Defining Autonomous Transactions

retry counter example : 2.5.3. Building a Retry Counter rules and restrictions : 2.4. Rules and Restrictions transaction management
: 2.1. Transaction Management in PL/SQL

transaction visibility : 2.4.2. Transaction Visibility using within SQL : 2.4.1. Using Autonomous Transactions from Within SQL when to use : 2.3. When to Use Autonomous Transactions Symbols | A | B | C | D | E | F | G | H | I | J | L | M | N | O | P | Q | R | S | T | U | V | W | X Copyright (c) 2000 O'Reilly & Associates. All rights reserved.