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.
|