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

Copyright (c) 2000 O'Reilly & Associates. All rights reserved.