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