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 : 1.4.4.2. Switching between public and private
  controlling with packages : 1.6.1.2. Maintain control over your data structures
  error, consistency of : 22.2.1.1. Recording consistent error data
  global
    (see global data)
    2.10.3. Simplifying Package Interfaces
  package : (see packages)
  private
    (see private data)
    (see private elements)
  program assumptions on : 3.7. Handling Program Assumptions
  public
    (see public data)
    (see public elements)
  supporting with overloading
    2.8.1.1. Supporting many data combinations
    2.8.1.3. Unambiguous, simple arguments
Data Definition Language (DDL) : 19.4.1. DDL Operations
database code repository : 12.2.2. Database Source or Target
database tables : (see tables)
datatypes : (see types)
date and time : 6.4.3. Retrieving Date and Time
  date format mask
    5.3.1. PL/Vision constants
    6.2. Setting the PL/Vision Date Mask
    7.1.2. Displaying Dates
  elapsed time
    5.27.5. Retrieving and displaying elapsed time
    14.3. Retrieving and Displaying the Elapsed Time
  elapsed time of : 5.27. PLVtmr: Program Performance Analyzer
  now function : 5.3.6. Miscellaneous programs
  timer : 14. PLVtmr: Analyzing Program Performance
  timer script : 16.2.9. Generating a Timer Script
  updating in tables : 19.5.3. Executing dynamic UPDATEs
datemask function
  5.3.3. Setting the date format mask
  6.2. Setting the PL/Vision Date Mask
DBMS_ TRANSACTION package : 1.5.1. Builtin Packages
DBMS_ALERT package : 1.5.1. Builtin Packages
DBMS_DDL package : 1.5.1. Builtin Packages
DBMS_DESCRIBE package
  DESCRIBE_PROCEDURE procedure : 17.2. Current Sources of Information
DBMS_JOB package : 1.5.1. Builtin Packages
DBMS_LOCK package : 1.5.1. Builtin Packages
DBMS_MAIL package : 1.5.1. Builtin Packages
DBMS_OUTPUT package
  1.5.1. Builtin Packages
  7.1.2. Displaying Dates
  22.3.2.2. Drawbacks of the usual handlers
  ENABLE procedure : 7.4. Controlling Output from p
  PUT_LINE function : 7. p: A Powerful Substitute for DBMS_OUTPUT
  PUT_LINE package
    (see also p package)
    5.2. p: a DBMS_OUTPUT Substitute
  PUT_LINE procedure : 2.8.1.1. Supporting many data combinations
DBMS_PIPE package
  1.5.1. Builtin Packages
  1.5.1.1. Leveraging builtin packages
DBMS_SESSION package : 1.5.1. Builtin Packages
DBMS_SHARED_POOL package : 1.4.3.1. Managing packages in shared memory
DBMS_SNAPSHOT package : 1.5.1. Builtin Packages
DBMS_SQL package
  1.5.1. Builtin Packages
  19. PLVdyn and PLVfk: Dynamic SQL and PL/SQL
  19.3. The Dynamic Packages of PL/Vision
  19.5.6.1. Open and parse
  BIND_VARIABLE : 5.20.8. Miscellaneous PLVobj programs
  EXECUTE procedure : 19.5.4. Checking feedback on DML
DBMS_STANDARD packages : 1.2. What Are the Types and Layers of Packages?
DBMS_UTILITY package : 1.5.1. Builtin Packages
  FORMAT_CALL_STACK function : 21.2.2. Accessing the PL/SQL Call Stack
  GET_TIME function : 14. PLVtmr: Analyzing Program Performance
  NAME_RESOLVE procedure : 11.3.2. Converting the Program Name
dbtab constant : 5.3.1. PL/Vision constants
DDL (Data Definition Language) : 19.4.1. DDL Operations
  schemas : 19.5.10.2. Avoiding schema confusion for DDL
  operations : 5.9.4. Data Definition Language operations
ddl procedure
  5.9.4. Data Definition Language operations
  19.4.1.1. Generic DDL interface
  19.5.6.3. Parse for delete
debugging code : 4.1.1. The Benefits of PL/Vision
debugging programs
  (see also tracing)
  2.6.3.1. The test/debug cycle in PL/SQL
  5.28.1. Package constants
declarative programming : 19.2. Declarative Programming in PL/SQL
declaring
  anchored declarations : 2.10.5. Anchoring to Public Variables
  cursors : 16.2.6. Generating a Cursor Declaration
  packages : 1.4.1. The Package Specification
  private before public : 2.2.1. Choosing the Order of Elements
  variables
    1.4.1. The Package Specification
    2.10.1. Gaining Control of Your Data
default
  date format mask : 6.2. Setting the PL/Vision Date Mask
  directory/folder : 5.11.4. Setting the default directory or location
  line separator : 7.2. The Line Separator
  message table names : 9.2.2. Batch Loading of Message Text
  PLVlog : 21.1.5.4. Setting the default "rollback to" behavior
  source WHERE clause : 12.4. The Source WHERE Clause
  string function values : 16.2.3.3. Default values for string functions
default directory : 13.2.2. Setting the Default Directory
defstk constant : 5.24.1. Package constants
deleteitem procedure : 5.18.3. Modifying list contents
deleting
  execution stack contents : 21.2.4.5. Emptying the stack
  from bailout error list : 22.1.10.1. Managing the bailout error list
  from tables : 19.5.2. Executing dynamic DELETEs
  PL/SQL table contents : 21.1.4.1. Counting and clearing the PL/SQL table
  stacks : 5.24.2. Creating and destroying stacks
  table rows : 8.6. Emptying Tables with PLVtab
  target repository contents : 12.9.3. Clearing the Target
delim function : 5.11.3. Setting the operating system delimiter
delim procedure : 13.2.1. Setting the Operating System Delimiter
delimiter
  customizing : 10.1.2. Customizing the Delimiter Set
  line separator : 7.2. The Line Separator
  operating system
    5.11.3. Setting the operating system delimiter
    13.2.1. Setting the Operating System Delimiter
  string : 5.21.1. Package constants
  UNIX and MS-DOS
    5.11.1. Package constants and exceptions
    13.2.1. Setting the Operating System Delimiter
dependency, identifying with PLVcat : 18.2.4. Identifying References and Dependencies
dependency, package : 2.4.1. Creating Codependent Packages
DESCRIBE command : 17.2. Current Sources of Information
designing programs : (see programming technique)
destroy procedure : 5.18.2. Creating and destroying lists
destroying : (see deleting)
DEV account : 4.4.1. Special Handling for PLVdyn
developer utilities : 4.2.2. Developer Utilities
developers : 2.5.1. Seeing Developers as Users
development
  1.3.6. Performance Improvement
  3. The PL/SQL Development Spiral
  upgrades and fixes : 1.6.1.6. Hide weaknesses to facilitate upgrades and fixes.
  of PL/Vision : 4.1.2. The Origins of PL/Vision
dir function
  5.11.4. Setting the default directory or location
  13.2.2. Setting the Default Directory
directories
  default : 13.2.2. Setting the Default Directory
  setting default : 5.11.4. Setting the default directory or location
directory, PL/Vision : 4.3.3. Beginning the Installation
disp_line procedure : 15.4.2.5. Moving to a PL/SQL-based solution
disp_text procedure : 15.4.1. How to Find Source Code
display function : 8.2. Displaying PLVtab Tables
display prefix : 8.5. Setting the Display Prefix
display procedure
  5.11.12. Displaying the contents of a file
  5.17.5. Reading the log
  5.25.8. Displaying a PLVtab table
  8.7. Implementing PLVtab.display
  13.8. Displaying File Contents
  21.1.6. Displaying the Log
display_atomics procedure
  5.21.4. Parsing strings
  10.1.3.2. display_atomics procedure
display_err procedure : 15.4.2.8. Fine-tuning code display
display_exception procedure : 22.3.3.4. Displaying the exception
display_line procedure : 15.4.2.8. Fine-tuning code display
display_row procedure : 8.7. Implementing PLVtab.display
display_wrap function : 5.21.2. Wrapping long strings into paragraphs
display_wrap procedure : 10.1.4.2. display_wrap procedure
display_wrap program : 8.2.1. Displaying Wrapped Text
displaying_module function
  5.28.4. Displaying current module
  21.2.1. Directing Output from PLVtrc
dispmod procedure
  5.28.4. Displaying current module
  21.2.1. Directing Output from PLVtrc
disptab procedure : 5.9.7. Miscellaneous programs
disptrg procedure
  5.15.6. Managing the target repository
  12.7.3. Displaying the Target Repository
distributed execution : 1.3.6. Performance Improvement
DMBS_LOCK page
  SLEEP procedure : 17.5.6.1. A futile first effort
DML statements
  1.6.1.5. Isolate volatile areas of functionality
  19.5. DML Operations
dml_delete procedure
  5.9.5. Data Manipulation Language operations
  19.5.2. Executing dynamic DELETEs
  19.5.6.3. Parse for delete
dml_insert_select procedure
  5.9.5. Data Manipulation Language operations
  19.5.1. Performing an INSERT-SELECT FROM
dml_update procedure
  5.9.5. Data Manipulation Language operations
  19.5.3. Executing dynamic UPDATEs
do_rb procedure : 21.1.5.6. Performing different kinds of rollbacks
do_rollback
  5.17.7. Rolling back in PLVlog
  21.1.5.1. Toggling rollback activity
documentation
  (see also help)
  2.2. Using Effective Coding Style for Packages
  comments : 16.3.7. Generating Online Help Text Stubs
  help generators : 5.13.5. Help generators
  online : 17. PLVhlp: Online Help for PL/SQL Programs
  online help
    4.4. Installing Online Help for PL/Vision
    4.5. Using Online Help
    5.14. PLVhlp: Online Help Architechture
    12.1. Why PLVio?
    generating : 16.3.7. Generating Online Help Text Stubs
  online reference : 4.3.4. Using the PL/Vision Lite Online Reference
DOS delimiter : 13.2.1. Setting the Operating System Delimiter
dot notation
  1.4.2. Referencing Package Elements
  2.3. Selecting Package Names
  2.3.2. Avoiding Redundancy
drop_object procedure
  5.9.4. Data Definition Language operations
  19.4.1.2. Dropping and truncating objects with PLVdyn
dumping DDL : (see DDL)

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

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