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

Book HomeTITLE OF BOOKSearch this book

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
The Oracle Library Navigation

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

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference