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: D

Data Definition Language (DDL)

1.3.3. Native Dynamic SQL (Chapter 4, Native Dynamic SQL in Oracle8i)

1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)

4.2.1. The EXECUTE IMMEDIATE Statement

data dictionary views : 8.4.3. Context Data Dictionary Views

Data Manipulation Language (DML)

1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!)

1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)

database administrator (DBA)

7.6.2. System-Level Access Control

1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)

database event publication feature : 6. New Trigger Features in Oracle8i

database logins, tracking : 6.2.1.2. Tracking logins to the database

database-level event triggers

1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!)

1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)

6. New Trigger Features in Oracle8i

6.2. Database-Level Event Triggers

DATABASE_NAME attribute, database-level event

6.2. Database-Level Event Triggers

6.3. Schema-Level Event Triggers

datatype mappings, legal : 9.8.3. Mapping Datatypes

DBA_CONTEXT data dictionary view : 8.4.3. Context Data Dictionary Views

DBA_ERRORS data dictionary view : 9.6.2. Examining Loaded Java Elements

DBA_OBJECTS data dictionary view : 9.6.2. Examining Loaded Java Elements

DBA_POLICIES data dictionary view : 8.4.3. Context Data Dictionary Views

DBA_SEGMENTS data dictionary view : 7.5.2.5. Managing temporary LOBs

DBMS_AQ package

1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)

7.6. New DBMS_AQ and DBMS_AQADM Features

DBMS_AQADM package : 7.6. New DBMS_AQ and DBMS_AQADM Features

DBMS_INDEXING package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_JAVA package

1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)

7. New and Enhanced Built-in Packages in Oracle8i

9.1. Oracle8i and Java

9.7. Using DBMS_JAVA and DBMS_JAVA_TEST

DBMS_JAVA_TEST package

7. New and Enhanced Built-in Packages in Oracle8i

9.1. Oracle8i and Java

9.7. Using DBMS_JAVA and DBMS_JAVA_TEST

9.7.5. Using DBMS_JAVA_TEST

DBMS_LOB package : 1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)

DBMS_LOG_MNR package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_LOG_MNR_D package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_OUTPUT package

2.4.1. Using Autonomous Transactions from Within SQL

7.6.4.2. LISTEN: Listening for messages

DBMS_PIPE package

2.4.1. Using Autonomous Transactions from Within SQL

6.2.1.3. Trapping system errors

DBMS_PROFILER package

1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)

7. New and Enhanced Built-in Packages in Oracle8i

DBMS_REPAIR package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_REPCAT_FLA package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_REPCAT_FLA_MAS package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_REPCAT_FLA_UTL package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_RESOURCE_MANAGER package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_RESOURCE_MANAGER_PRIVS package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_RLS package

1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)

7. New and Enhanced Built-in Packages in Oracle8i

7.3. DBMS_RLS: Implementing Fine-Grained Access Control

8.1. FGAC Components

DBMS_RULE package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_RULE_ADM package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_RULE_EXIMP package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_SPACE_ADMIN package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_SQL compared to native dynamic SQL : 4.1. DBMS_SQL Versus NDS

DBMS_SQL package

1.3.2. Invoker Rights (Chapter 3, Invoker Rights: Your Schema or Mine? )

3.1.4. Dynamic SQL and Definer Rights

4.1. DBMS_SQL Versus NDS

DBMS_STATS package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_SUMMARY package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_TRACE package

1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)

7. New and Enhanced Built-in Packages in Oracle8i

7.2. DBMS_TRACE: Providing a PL/SQL Trace Facility

DBMS_TTS package : 7. New and Enhanced Built-in Packages in Oracle8i

DBMS_UTILITY package

1.3.6. New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)

7.7. New DBMS_UTILITY Features

dbmspbp.sql file : 7.1.2. Installing DBMS_PROFILER

DDL (Data Definition Language)

1.3.3. Native Dynamic SQL (Chapter 4, Native Dynamic SQL in Oracle8i)

1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)

4.2.1. The EXECUTE IMMEDIATE Statement

deadlock example : 2.4. Rules and Restrictions

DECLARE statement : 4.6.3. Dynamic PL/SQL

deep copies : 7.5.2.5. Managing temporary LOBs

define_variable, EXECUTE IMMEDIATE statement : 4.2.1. The EXECUTE IMMEDIATE Statement

definer rights models : 7.3.4. ADD_POLICY: Adding a Policy

DEL column, *_POLICIES data dictionary views : 8.4.3. Context Data Dictionary Views

DELETE statement

1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)

3.2.2. Some Rules and Restrictions

4. Native Dynamic SQL in Oracle8i

6. New Trigger Features in Oracle8i

deleting files from PL/SQL : 9.3.5. Deleting Files from PL/SQL

DEQUEUE option, GRANT_QUEUE_PRIVILEGE procedure : 7.6.3.1. GRANT_QUEUE_PRIVILEGE: Granting queue-level privileges

DEQUEUE procedure, DBMS_AQ package : 7.6.4.2. LISTEN: Listening for messages

DEQUEUE_ANY option, GRANT_SYSTEM_PRIVILEGE procedure : 7.6.2.1. GRANT_SYSTEM_PRIVILEGE: Granting system-level privileges

DES_ENCRYPTED_PASSWORD attribute, schema-level event : 6.3. Schema-Level Event Triggers

DETERMINISTIC keyword

1.3.9. Miscellaneous New Features and Performance Improvements (Chapter 10, More Goodies for Oracle8i PL/SQL Developers)

10.2.2.2. Deterministic functions

DICTIONARY_OBJ_NAME attribute, schema-level events : 6.3. Schema-Level Event Triggers

DICTIONARY_OBJ_OWNER attribute, schema-level events : 6.3. Schema-Level Event Triggers

DICTIONARY_OBJ_TYPE attribute, schema-level events : 6.3. Schema-Level Event Triggers

diffcount.sql file : 5.2. Bulk DML with the FORALL Statement

directory contents, obtaining : 9.9.1.2. Obtaining directory contents

disk accompanying book : A. Appendix: What's on the Companion Disk?

DML (Data Manipulation Language)

1.3.1. Autonomous Transactions (Chapter 2, Choose Your Transaction!)

1.3.5. New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)

DROP JAVA statement : 9.1. Oracle8i and Java

DROP statement

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

DROP_POLICY procedure, DBMS_RLS package

7.3.2. DBMS_RLS Programs

7.3.6. DROP_POLICY: Dropping a Policy

dropjava utility

9.1. Oracle8i and Java

9.5. Using dropjava

duplicate placeholders : 4.4.4. Duplicate Placeholders

duplicate placeholders, native dynamic SQL : 4.4.4. Duplicate Placeholders

dur parameter, CREATETEMPORARY procedure : 7.5.2.1. CREATETEMPORARY: Creating a temporary LOB

dynamic cursors : 4.1. DBMS_SQL Versus NDS

dynamic ids : 9.2.3. Setting Oracle Privileges

dynamic PL/SQL : 4.6.3. Dynamic PL/SQL

dynamic SQL

blocks, scope of variables : 4.6.3. Dynamic PL/SQL

cursors, reusing : 4.1. DBMS_SQL Versus NDS

Method 4 : 4.1. DBMS_SQL Versus NDS

dynPLSQL program, ndsutil.pkg file : 4.7. NDS Utility Package

dynplsql.sp : 4.6.3. Dynamic PL/SQL

dynvar.pkg file : 4.6.3. Dynamic PL/SQL

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