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

Index: D

• data
• • changing accessibility of : Switching between public and private
  • controlling with packages : Maintain control over your data structures
  • error, consistency of : Recording consistent error data
  • global
  • • (see global data)
    • Simplifying Package Interfaces
  • package : (see packages)
  • private
  • • (see private data)
    • (see private elements)
  • program assumptions on : Handling Program Assumptions
  • public
  • • (see public data)
    • (see public elements)
  • supporting with overloading
  • • Supporting many data combinations
    • Unambiguous, simple arguments
• Data Definition Language (DDL) : DDL Operations
• database code repository : Database Source or Target
• database tables : (see tables)
• datatypes : (see types)
• date and time : Retrieving Date and Time
• • date format mask
  • • PL/Vision constants
    • Setting the PL/Vision Date Mask
    • Displaying Dates
  • elapsed time
  • • Retrieving and displaying elapsed time
    • Retrieving and Displaying the Elapsed Time
  • elapsed time of : PLVtmr: Program Performance Analyzer
  • now function : Miscellaneous programs
  • timer : PLVtmr: Analyzing Program Performance
  • timer script : Generating a Timer Script
  • updating in tables : Executing dynamic UPDATEs
• datemask function
• • Setting the date format mask
  • Setting the PL/Vision Date Mask
• DBMS_ TRANSACTION package : Builtin Packages
• DBMS_ALERT package : Builtin Packages
• DBMS_DDL package : Builtin Packages
• DBMS_DESCRIBE package
• • DESCRIBE_PROCEDURE procedure : Current Sources of Information
• DBMS_JOB package : Builtin Packages
• DBMS_LOCK package : Builtin Packages
• DBMS_MAIL package : Builtin Packages
• DBMS_OUTPUT package
• • Builtin Packages
  • Displaying Dates
  • Drawbacks of the usual handlers
  • ENABLE procedure : Controlling Output from p
  • PUT_LINE function : A Powerful Substitute for DBMS_OUTPUT
  • PUT_LINE package
  • • (see also package)
    • a DBMS_OUTPUT Substitute
  • PUT_LINE procedure : Supporting many data combinations
• DBMS_PIPE package
• • Builtin Packages
  • Leveraging builtin packages
• DBMS_SESSION package : Builtin Packages
• DBMS_SHARED_POOL package : Managing packages in shared memory
• DBMS_SNAPSHOT package : Builtin Packages
• DBMS_SQL package
• • Builtin Packages
  • PLVdyn and PLVfk: Dynamic SQL and PL/SQL
  • The Dynamic Packages of PL/Vision
  • Open and parse
  • BIND_VARIABLE : Miscellaneous PLVobj programs
  • EXECUTE procedure : Checking feedback on DML
• DBMS_STANDARD packages : What Are the Types and Layers of Packages?
• DBMS_UTILITY package : Builtin Packages
• • FORMAT_CALL_STACK function : Accessing the PL/SQL Call Stack
  • GET_TIME function : PLVtmr: Analyzing Program Performance
  • NAME_RESOLVE procedure : Converting the Program Name
• dbtab constant : PL/Vision constants
• DDL (Data Definition Language) : DDL Operations
• • schemas : Avoiding schema confusion for DDL
  • operations : Data Definition Language operations
• ddl procedure
• • Data Definition Language operations
  • Generic DDL interface
  • Parse for delete
• debugging code : The Benefits of PL/Vision
• debugging programs
• • (see also tracing)
  • The test/debug cycle in PL/SQL
  • Package constants
• declarative developing : Declarative Developing in PL/SQL
• declaring
• • anchored declarations : Anchoring to Public Variables
  • cursors : Generating a Cursor Declaration
  • packages : The Package Specification
  • private before public : Choosing the Order of Elements
  • variables
  • • The Package Specification
    • Gaining Control of Your Data
• default
• • date format mask : Setting the PL/Vision Date Mask
  • directory/folder : Setting the default directory or location
  • line separator : The Line Separator
  • message table names : Batch Loading of Message Text
  • PLVlog : Setting the default "rollback to" behavior
  • source WHERE clause : The Source WHERE Clause
  • string function values : Default values for string functions
• default directory : Setting the Default Directory
• defstk constant : Package constants
• deleteitem procedure : Modifying list contents
• deleting
• • execution stack contents : Emptying the stack
  • from bailout error list : Managing the bailout error list
  • from tables : Executing dynamic DELETEs
  • PL/SQL table contents : Counting and clearing the PL/SQL table
  • stacks : Creating and destroying stacks
  • table rows : Emptying Tables with PLVtab
  • target repository contents : Clearing the Target
• delim function : Setting the operating system delimiter
• delim procedure : Setting the Operating System Delimiter
• delimiter
• • customizing : Customizing the Delimiter Set
  • line separator : The Line Separator
  • operating system
  • • Setting the operating system delimiter
    • Setting the Operating System Delimiter
  • string : Package constants
  • UNIX and MS-DOS
  • • Package constants and exceptions
    • Setting the Operating System Delimiter
• dependency, identifying with PLVcat : Identifying References and Dependencies
• dependency, package : Creating Codependent Packages
• DESCRIBE command : Current Sources of Information
• designing programs : (see developing technique)
• destroy procedure : Creating and destroying lists
• destroying : (see deleting)
• DEV account : Special Handling for PLVdyn
• developer utilities : Developer Utilities
• developers : Seeing Developers as Users
• development
• • Performance Improvement
  • The PL/SQL Development Spiral
  • upgrades and fixes : Hide weaknesses to facilitate upgrades and fixes.
  • of PL/Vision : The Origins of PL/Vision
• dir function
• • Setting the default directory or location
  • Setting the Default Directory
• directories
• • default : Setting the Default Directory
  • setting default : Setting the default directory or location
• directory, PL/Vision : Beginning the Installation
• disp_line procedure : Moving to a PL/SQL-based solution
• disp_text procedure : How to Find Source Code
• display function : Displaying PLVtab Tables
• display prefix : Setting the Display Prefix
• display procedure
• • Displaying the contents of a file
  • Reading the log
  • Displaying a PLVtab table
  • Implementing PLVtab.display
  • Displaying File Contents
  • Displaying the Log
• display_atomics procedure
• • Parsing strings
  • display_atomics procedure
• display_err procedure : Fine-tuning code display
• display_exception procedure : Displaying the exception
• display_line procedure : Fine-tuning code display
• display_row procedure : Implementing PLVtab.display
• display_wrap function : Wrapping long strings into paragraphs
• display_wrap procedure : display_wrap procedure
• display_wrap program : Displaying Wrapped Text
• displaying_module function
• • Displaying current module
  • Directing Output from PLVtrc
• dispmod procedure
• • Displaying current module
  • Directing Output from PLVtrc
• disptab procedure : Miscellaneous programs
• disptrg procedure
• • Managing the target repository
  • Displaying the Target Repository
• distributed execution : Performance Improvement
• DMBS_LOCK page
• • SLEEP procedure : futile first effort
• DML statements
• • Isolate volatile areas of functionality
  • DML Operations
• dml_delete procedure
• • Data Manipulation Language operations
  • Executing dynamic DELETEs
  • Parse for delete
• dml_insert_select procedure
• • Data Manipulation Language operations
  • Performing an INSERT-SELECT FROM
• dml_update procedure
• • Data Manipulation Language operations
  • Executing dynamic UPDATEs
• do_rb procedure : Performing different kinds of rollbacks
• do_rollback
• • Rolling back in PLVlog
  • Toggling rollback activity
• documentation
• • (see also help)
  • Using Effective Coding Style for Packages
  • comments : Generating Online Help Text Stubs
  • help generators : Help generators
  • online : PLVhlp: Online Help for PL/SQL Programs
  • online help
  • • Installing Online Help for PL/Vision
    • Using Online Help
    • PLVhlp: Online Help Architechture
    • Why PLVio?
    • generating : Generating Online Help Text Stubs
  • online reference : Using the PL/Vision Lite Online Reference
• DOS delimiter : Setting the Operating System Delimiter
• dot notation
• • Referencing Package Elements
  • Selecting Package Names
  • Avoiding Redundancy
• drop_object procedure
• • Data Definition Language operations
  • Dropping and truncating objects with PLVdyn
• dumping DDL : (see DDL)