Book HomeBook HomeSearch this book

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
The Oracle Library Navigation

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

Library Home Oracle PL/SQL Programming, 2nd. Ed. Guide to Oracle 8i Features Oracle Built-in Packages Advanced PL/SQL Programming with Packages Oracle Web Applications Oracle PL/SQL Language Pocket Reference Oracle PL/SQL Built-ins Pocket Reference