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.