Symbols | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | Y | Z

Index: D

• dangling REFs : Adding Complex Data Structures
• data
• • abstract datatypes : (see ADTs)
  • abstraction : Data abstraction
  • combining scalars and aggregates : Combining Scalar and Aggregate Values
  • denormalizing with nested records : Denormalizing Program Data with Nested Records
  • errors by implicit cursors : Vulnerability to data errors
  • from packages, performance and : Use Package Data to Avoid Passing "Bulky" Parameter Values
  • global
  • • (see also global variables)
    • Object Persistence
    • Global Within a Single Oracle Session
    • Avoid Global Variables and Data Structures
    • private : Global Private Data
    • public : Global Public Data
  • object model and : Combining data with behavior
  • package : Package Data
  • program : (see variables)
  • records : (see records)
  • tuning access to : Tuning Access to Your Data
  • verifying : Test All Assumptions
• data abstraction : Abstraction
• data dictionary
• • external procedure entries : Data Dictionary
  • for managing collections : Data Dictionary
  • object types entries : Data Dictionary
  • object views entries : Data Dictionary
• data structures, synchronizing : Synchronize Program and Data Structures
• databases
• • administration of : About the Contents
  • communication between sessions : DBMS_PIPE
  • cursor-based access to : Cursor-based access to the database
  • events, receiving notification of : DBMS_ALERT
  • locking records : SELECT FOR UPDATE in Cursors
  • managing code in : Managing Code in the Database
  • structure for objects : DDL usage
  • synchroniztion with columns : Synchronization with database columns
  • triggers : (see triggers)
  • tuning of : About the Contents
• datatypes : Scalar Datatypes
• • abstract
  • • (see abstract datatypes)
    • (see ADTs)
  • anchored
  • • Anchored declarations
    • Anchored Declarations
  • collections as : Collections in PL/SQL
  • comverting
  • • external procedures and : Datatype Conversion
  • constrained/unconstrained : Constrained Declarations
  • converting
  • • performance and : Avoid Type Conversions When Possible
  • converting between
  • • Conversion Between Datatypes
    • Conversion Functions
  • declaring in tables
  • • Defining the Table TYPE
    • PL/SQL Tables of Records
  • external : Datatype Conversion
  • for LOB variables : Large object support
  • for LOBs : LOB Datatypes
  • object : (see object types)
  • for overloaded modules : Restrictions on Overloading
  • PL/SQL Version 2.0 : No Server-Side PL/SQL Datatypes
  • developer-defined : (see subtypes)
  • standardizing with %TYPE : Use %TYPE to Standardize Nondatabase Declarations
  • of stored functions parameters : Requirements for Stored Functions in SQL
• date
• • Date Functions
  • Building a Date Manager
  • changing millenia : RR: Changing Millenia
  • converting strings to/from
  • • Conversion Formats
    • The TO_CHAR function (date conversion)
    • The TO_DATE function
  • DATE datatype : The Date-Time Datatype
  • range : Using TO_CHAR to Create a Date Range
  • system : The SYSDATE function
• DATE datatype : Date Functions
• days : (see date)
• DB2 data source : The CHAR datatype
• dbgextp.sql script : Rules and Warnings About External Procedures
• DBMS_AQ package : Oracle AQ, the Advanced Queueing Facility
• DBMS_AQADM package : DBMS_AQADM (PL/SQL 8 Only)
• DBMS_DDL package : DBMS_DDL
• DBMS_DESCRIBE package
• • pinning in SGA shared pool : Candidates for pinning in the shared pool
• DBMS_JOB package
• • DBMS_ JOB
  • Job scheduling with DBMS_ JOB
• DBMS_LOB package : DBMS_LOB (PL/SQL8 Only)
• DBMS_LOCK package : DBMS_LOCK
• DBMS_MAIL package : DBMS_MAIL
• DBMS_OUTPUT package
• • DBMS_OUTPUT
  • Displaying a PL/SQL Table
  • Quick-and-Dirty Tracing
  • pinning in SGA shared pool : Candidates for pinning in the shared pool
• DBMS_PIPE package : DBMS_PIPE
• DBMS_ROWID package : DBMS_ROWID (PL/SQL8 Only)
• DBMS_SESSION package : DBMS_SESSION
• DBMS_SHARED_POOL package : Pin Critical Code into the SGA
• DBMS_SNAPSHOT package : DBMS_SNAPSHOT
• DBMS_SQL package : DBMS_SQL
• • batch processing : Take Advantage of DBMS_SQL Batch Processing
• DBMS_STANDARD package
• • pinning in SGA shared pool : Candidates for pinning in the shared pool
• DBMS_TRANSACTION package : DBMS_TRANSACTION
• DBMS_UTILITY package : DBMS_UTILITY
• • GET_TIME Function : Use the DBMS_UTILITY.GET_TIME Function
  • pinning in SGA shared pool : Candidates for pinning in the shared pool
• DDL (Data Definition Language)
• • DBMS_DDL package for : DBMS_DDL
  • object privileges and : DDL
  • statements : Support for DDL and dynamic SQL
• debugging
• • Multiline Comment Syntax
  • Debugging PL/SQL
  • external procedures : Rules and Warnings About External Procedures
  • finding code by line number : Finding the Code for a Line Number
  • messages about, in packages : Build Debugging Messages into Your Packages
  • strategies for : Debugging Tips and Strategies
  • tracing PL/SQL execution : Tracing PL/SQL Execution
• DEC subtype : Numeric Subtypes
• decimal datatypes
• • Decimal numeric datatypes
  • Numeric Subtypes
• DECIMAL subtype : Numeric Subtypes
• declarations
• • anchored
  • • Anchored declarations
    • Anchored Declarations
  • commenting : Comment Declaration Statements
  • FOR loop indexes : Structured Code and Other Best Practices
  • formatting : Formatting Your Declarations
  • forward : Forward Declarations
  • in packages
  • • The Package Specification
    • Declare in Specification or Body
  • of record TYPEs : Declaring Developer-Defined Record TYPEs
  • of records
  • • Declaring Records with the %ROWTYPE Attribute
    • Declaring the Record
  • subtype : Declaring Subtypes
  • of tables : Declaring a PL/SQL Table
  • unconstrained : Defining the Parameters
  • variable : Variable Declarations
• declaring
• • collection datatypes : Syntax for Declaring Collection Datatypes
  • cursor variables : Declaring REF CURSOR Types and Cursor Variables
  • cursors : Declaring Cursors
  • exceptions raised in declarations : Exceptions Raised in a Declaration
  • parameters : Correct Declaration of Properties
• DECODE function
• • in MAKE_REF funfction : Working around the ORA-22972 problem
• DECODE function, replacing with IF : Replacing DECODEs with IF Statements
• default
• • constructor method : About Object Types
  • parameter values
  • • No Default Parameter Values
    • Default Values
    • Default Values and Remote Procedure Calls
  • records : Record Initialization
  • values for variables : Default Values
• DEFAULT keyword : Default Values
• DEFINE_ARRAY program : Take Advantage of DBMS_SQL Batch Processing
• DEFINE_COLUMN procedure : The DEFINE_COLUMN procedure
• definer rights model : Rights model
• DELETE procedure : The DELETE procedure
• • removing collection elements : Removing elements using DELETE
  • THE function with : The THE Pseudo-function
• DELETE statement
• • (see also DML statements)
  • PL/SQL Tables and DML Statements
  • WHERE CURRENT OF clause : The WHERE CURRENT OF Clause
• deleting
• • collection elements : Adding and Removing Elements
  • table rows : The DELETE procedure
• deleting tables : Clearing the PL/SQL Table
• denormalizing program data : Denormalizing Program Data with Nested Records
• dependency management : Module Validation and Dependency Management
• DEQUEUE procedure : The DEQUEUE procedure
• DEREF function, virtual REFs and : DEREF: Interpreting a virtual REF
• DEREF operator : DEREF
• desc command (SQL*Plus), objects and : SQL*Plus "Describe" Command
• Developer/2000 : Implications for Developer/2000
• development
• • best practices for : Best Practices for PL/SQL Excellence
  • packages for : Center All Development Around Packages
  • standarizing environment for : Standardize Your PL/SQL Development Environment
• digits, number of : (see precision)
• direct field assignment
• • Assigning Values to and from Records
  • Direct Assignment
• directories, creating : Working with BFILEs
• directory aliases, BFILENAME functions and : The BFILENAME function
• DISABLE procedure : The DISABLE procedure
• disk accompanying this tutorial : What's on the Companion Disk?
• disk space : (see memory)
• DMBS_ALERT package : DBMS_ALERT
• DML
• • encapsulating in object views : INSTEAD OF Triggers
  • encapsulating in packages : Approach 4: Use an Object and a PL/SQL Container Package
  • object privileges and : DML
• DML statements : Support for DDL and dynamic SQL
• • and tables : PL/SQL Tables and DML Statements
• "do nothing" statement : (see NULL statements)
• documentation
• • with encrypted code : Impact of Encrypting Code
  • of parameters : Document All Parameters and Their Functions
  • of developing process : Document and Back Up Your Efforts
• documentation, inline : (see comments)
• dot notation
• • No Direct Stored Package Variable References
  • Accessing Record-Based Data
  • Dot Notation
  • with nested records : Dot Notation with Nested Records
• DOUBLE PRECISION subtype : Numeric Subtypes
• DROP command
• • DROP: Dropping Views and Triggers
  • DROP: Dropping Libraries
  • Changing Stored Objects
• DROP TYPE statement : CREATE TYPE and DROP TYPE: Creating and Dropping Types
• DROP_QUEUE procdure : The DROP_QUEUE procedure
• DROP_QUEUE_TABLE procedure : The DROP_QUEUE_TABLE procedure
• DROP_SNAPSHOT procedure : The DROP_SNAPSHOT procedure
• dropping
• • libraries : DROP: Dropping Libraries
  • triggers : DROP: Dropping Views and Triggers
  • views : DROP: Dropping Views and Triggers
• dummy programs : Supporting top-down design of modules
• DUMP function : The DUMP function
• DUP_VAL_ON_INDEX exception : Named System Exceptions
• dynamic linking : Architecture
• dynamic SQL
• • DBMS_SQL
  • Support for DDL and dynamic SQL
  • Types of Cursors