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)

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