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)
• • Native Dynamic SQL (Chapter 4, Native Dynamic SQL in Oracle8i)
  • New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)
  • The EXECUTE IMMEDIATE Statement
• data dictionary views : Context Data Dictionary Views
• Data Manipulation Language (DML)
• • Autonomous Transactions (Chapter 2, Choose Your Transaction!)
  • New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)
• database administrator (DBA)
• • System-Level Access Control
  • New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)
• database event publication feature : New Trigger Features in Oracle8i
• database logins, tracking : Tracking logins to the database
• database-level event triggers
• • Autonomous Transactions (Chapter 2, Choose Your Transaction!)
  • New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)
  • New Trigger Features in Oracle8i
  • Database-Level Event Triggers
• DATABASE_NAME attribute, database-level event
• • Database-Level Event Triggers
  • Schema-Level Event Triggers
• datatype mappings, legal : Mapping Datatypes
• DBA_CONTEXT data dictionary view : Context Data Dictionary Views
• DBA_ERRORS data dictionary view : Examining Loaded Java Elements
• DBA_OBJECTS data dictionary view : Examining Loaded Java Elements
• DBA_POLICIES data dictionary view : Context Data Dictionary Views
• DBA_SEGMENTS data dictionary view : Managing temporary LOBs
• DBMS_AQ package
• • New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)
  • New DBMS_AQ and DBMS_AQADM Features
• DBMS_AQADM package : New DBMS_AQ and DBMS_AQADM Features
• DBMS_INDEXING package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_JAVA package
• • New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)
  • New and Enhanced Built-in Packages in Oracle8i
  • Oracle8i and Java
  • Using DBMS_JAVA and DBMS_JAVA_TEST
• DBMS_JAVA_TEST package
• • New and Enhanced Built-in Packages in Oracle8i
  • Oracle8i and Java
  • Using DBMS_JAVA and DBMS_JAVA_TEST
  • Using DBMS_JAVA_TEST
• DBMS_LOB package : New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)
• DBMS_LOG_MNR package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_LOG_MNR_D package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_OUTPUT package
• • Using Autonomous Transactions from Within SQL
  • LISTEN: Listening for messages
• DBMS_PIPE package
• • Using Autonomous Transactions from Within SQL
  • Trapping system errors
• DBMS_PROFILER package
• • New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)
  • New and Enhanced Built-in Packages in Oracle8i
• DBMS_REPAIR package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_REPCAT_FLA package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_REPCAT_FLA_MAS package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_REPCAT_FLA_UTL package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_RESOURCE_MANAGER package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_RESOURCE_MANAGER_PRIVS package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_RLS package
• • New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)
  • New and Enhanced Built-in Packages in Oracle8i
  • DBMS_RLS: Implementing Fine-Grained Access Control
  • FGAC Components
• DBMS_RULE package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_RULE_ADM package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_RULE_EXIMP package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_SPACE_ADMIN package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_SQL compared to native dynamic SQL : DBMS_SQL Versus NDS
• DBMS_SQL package
• • Invoker Rights (Chapter 3, Invoker Rights: Your Schema or Mine? )
  • Dynamic SQL and Definer Rights
  • DBMS_SQL Versus NDS
• DBMS_STATS package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_SUMMARY package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_TRACE package
• • New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)
  • New and Enhanced Built-in Packages in Oracle8i
  • DBMS_TRACE: Providing a PL/SQL Trace Facility
• DBMS_TTS package : New and Enhanced Built-in Packages in Oracle8i
• DBMS_UTILITY package
• • New and Enhanced Built-in Packages (Chapter 7, New and Enhanced Built-in Packages in Oracle8i)
  • New DBMS_UTILITY Features
• dbmspbp.sql file : Installing DBMS_PROFILER
• DDL (Data Definition Language)
• • Native Dynamic SQL (Chapter 4, Native Dynamic SQL in Oracle8i)
  • New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)
  • The EXECUTE IMMEDIATE Statement
• deadlock example : Rules and Restrictions
• DECLARE statement : Dynamic PL/SQL
• deep copies : Managing temporary LOBs
• define_variable, EXECUTE IMMEDIATE statement : The EXECUTE IMMEDIATE Statement
• definer rights models : ADD_POLICY: Adding a Policy
• DEL column, *_POLICIES data dictionary views : Context Data Dictionary Views
• DELETE statement
• • New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)
  • Some Rules and Restrictions
  • Native Dynamic SQL in Oracle8i
  • New Trigger Features in Oracle8i
• deleting files from PL/SQL : Deleting Files from PL/SQL
• DEQUEUE option, GRANT_QUEUE_PRIVILEGE procedure : GRANT_QUEUE_PRIVILEGE: Granting queue-level privileges
• DEQUEUE procedure, DBMS_AQ package : LISTEN: Listening for messages
• DEQUEUE_ANY option, GRANT_SYSTEM_PRIVILEGE procedure : GRANT_SYSTEM_PRIVILEGE: Granting system-level privileges
• DES_ENCRYPTED_PASSWORD attribute, schema-level event : Schema-Level Event Triggers
• DETERMINISTIC keyword
• • Miscellaneous New Features and Performance Improvements (Chapter 10, More Goodies for Oracle8i PL/SQL Developers)
  • Deterministic functions
• DICTIONARY_OBJ_NAME attribute, schema-level events : Schema-Level Event Triggers
• DICTIONARY_OBJ_OWNER attribute, schema-level events : Schema-Level Event Triggers
• DICTIONARY_OBJ_TYPE attribute, schema-level events : Schema-Level Event Triggers
• diffcount.sql file : Bulk DML with the FORALL Statement
• directory contents, obtaining : Obtaining directory contents
• disk accompanying tutorial : Appendix: What's on the Companion Disk?
• DML (Data Manipulation Language)
• • Autonomous Transactions (Chapter 2, Choose Your Transaction!)
  • New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)
• DROP JAVA statement : Oracle8i and Java
• DROP statement
• • New Trigger Capabilities (Chapter 6, New Trigger Features in Oracle8i)
  • New Trigger Features in Oracle8i
  • Schema-Level Event Triggers
• DROP_POLICY procedure, DBMS_RLS package
• • DBMS_RLS Programs
  • DROP_POLICY: Dropping a Policy
• dropjava utility
• • Oracle8i and Java
  • Using dropjava
• duplicate placeholders : Duplicate Placeholders
• duplicate placeholders, native dynamic SQL : Duplicate Placeholders
• dur parameter, CREATETEMPORARY procedure : CREATETEMPORARY: Creating a temporary LOB
• dynamic cursors : DBMS_SQL Versus NDS
• dynamic ids : Setting Oracle Privileges
• dynamic PL/SQL : Dynamic PL/SQL
• dynamic SQL
• • blocks, scope of variables : Dynamic PL/SQL
  • cursors, reusing : DBMS_SQL Versus NDS
  • Method 4 : DBMS_SQL Versus NDS
• dynPLSQL program, ndsutil.pkg file : NDS Utility Package
• dynplsql.sp : Dynamic PL/SQL
• dynvar.pkg file : Dynamic PL/SQL