start page | rating of books | rating of authors | reviews | copyrights
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: P
- p package
- 2.8.1.1. Supporting many data combinations
- 4.2.1. Building Blocks
- 5.2. p: a DBMS_OUTPUT Substitute
- 7. p: A Powerful Substitute for DBMS_OUTPUT
- l : (see l procedure)
- output from : 7.4. Controlling Output from p
- package libraries : 1.5.2. Prebuilt Packages
- packages
- (see also modularizing)
- A.1.6. Builtin Packages
- 1.1. What Is a PL/SQL Package?
- 2.9. Modularizing for Maintainable Packages
- 5.13.6. Generating a package
- access to elements : 1.4.4. Access to Package Elements
- building : 1.6. Building Packages
- built-in : A.2.6. Builtin Packages
- codependency : 2.4.1. Creating Codependent Packages
- effective coding of : 2. Best Practices for Packages
- exception : (see PLVexc packages)
- exception section : 1.6.3.2. The exception section
- flexibility : 2.6. Building Flexibility Into Your Packages
- generating : 16.2.1. Generating a Package
- help : (see documentation)
- hiding elements of
- 1.3.1. Enforced Information Hiding
- 2.7. Building Windows Into Your Packages
- 2.10. Hiding Package Data
- in PL/Vision
- 4.2. PL/Vision Package Bundles
- 4.3.5. Creating the PL/Vision Packages
- 5. PL/Vision Package Specifications
- initializing
- 1.6.3. The Initialization Section
- 1.6.5.2. Asserting the purity level of the initialization section
- interface
- 2.5. Constructing the Optimal Interface to Your Package
- 2.10.3. Simplifying Package Interfaces
- layering : 2.9. Modularizing for Maintainable Packages
- memory architecture : 1.4.3. The Memory-Resident Architecture of Packages
- memory requirements : 4.3.2. Storage Requirements
- multiple, constructing : 2.11. Simultaneous Construction of Multiple Packages
- naming : 2.3. Selecting Package Names
- online help : (see PLVhlp package)
- ordering elements of : 2.2.1. Choosing the Order of Elements
- package body
- 1.6. Building Packages
- 1.6.2. The Package Body
- package specification
- 1.4.1. The Package Specification
- 1.6. Building Packages
- PL/SQL : 19.2. Declarative Programming in PL/SQL
- PLVctlg table : 18.2.2.1. PLVctlg table
- recompiling : 2.4. Organizing Package Source Code
- referencing elements of : 1.4.2. Referencing Package Elements
- synonyms for : 4.3.6. Granting Access to PL/Vision
- windows in : 2.7. Building Windows Into Your Packages
- working with large : 1.6.4. Working with Large Packages
- page size
- 17.4.2. Setting the Page Size
- 17.5.6.4. Maintaining the current page variables
- online help : 5.14.2. Setting the page size
- pagesize function : 17.4.2. Setting the Page Size
- paragraphs
- 5.21.2. Wrapping long strings into paragraphs
- 10.1.4. Wrapping Strings into Paragraphs
- parallelization of programs : 1.5.1.1. Leveraging builtin packages
- parameter list : 16.2.2.2. A procedure with parameter list and executable code
- PARSE procedure : 19.5.6.1. Open and parse
- parse tree : 1.6.4. Working with Large Packages
- parse_delete procedure
- 5.9.3. Bundled, low-level operations
- 19.5.6.3. Parse for delete
- parse_name procedure
- 5.11.13. Miscellaneous operations
- 13.2.3. Parsing the File Name
- parsing
- code : 5.22. PLVprsps: PL/SQL Source Code Parsing
- delimiter, defining : 10.1.2. Customizing the Delimiter Set
- file name : 13.2.3. Parsing the File Name
- PL/SQL code : 10.3.2. Parsing PL/SQL Code
- program names : 11.3.2. Converting the Program Name
- strings
- 5.16. PLVlex: Lexical Analysis
- 5.21. PLVprs: String Parsing
- 10. PLVprs, PLVtkn, and PLVprsps: Parsing Strings
- partial installation : 4.4.4. A Warning About Partial Installation
- pauding programs : 5.3.6. Miscellaneous programs
- pause procedure
- 5.3.6. Miscellaneous programs
- 6.4.4. Pausing Your Program
- pausing help text (see more procedure)
- pausing programs
- 6.4.4. Pausing Your Program
- A.2.6. Builtin Packages
- perform_commit procedure
- 5.7.3. Performing commits
- 20.1.2. The COMMIT Substitute
- perform_rollback function
- 5.23.3. Performing rollbacks
- 20.2.4. Performing Rollbacks
- performance
- A.2.6. Builtin Packages
- 1.3.6. Performance Improvement
- 3.10. Choosing the Best Performer
- 5.27.6. Calibration and timing scripts
- 14. PLVtmr: Analyzing Program Performance
- dynamic PL/SQL : 19.5.5.3. The overhead of dynamic PL/SQL
- package size : 1.6.4. Working with Large Packages
- permissions : (see access)
- persistence
- 1.3.4. Object Persistence
- 1.6.1.3. Need global data structures for your PL/SQL programs
- pinning code into memory : 1.4.3.1. Managing packages in shared memory
- pkg procedure
- 5.13.6. Generating a package
- 16.2.1. Generating a Package
- pky procedure : 5.8.3. Dumping the DDL
- PL/SQL
- call stack : 21.2.2. Accessing the PL/SQL Call Stack
- code, parsing : 10.3.2. Parsing PL/SQL Code
- declarative programming : 19.2. Declarative Programming in PL/SQL
- dynamic code : 19.5.5. Executing Dynamic PL/SQL Code
- objects : 11. PLVobj: A Packaged Interface to ALL_OBJECTS
- performance and : 19.5.5.3. The overhead of dynamic PL/SQL
- reserved words : 5.26. PLVtkn: Token Table Interface
- source code repositories : 12. PLVio: Reading and Writing PL/SQL Source Code
- tokens : (see reserved words)
- PL/Vision : 4.1. What Is PL/Vision?
- bindobj procedure in : 11.5.3. Using bindobj in PL/Vision
- cataloging : 18.2.3.4. Cataloguing PL/Vision
- enhancing PLVexc with : 22.3.4. Revamping the PLVexc Package
- installing : 4.3. Installation Instructions
- logging : (see logging)
- loopexec procedure in : 11.7.4. Applying loopexec in PL/Vision
- packages of
- 4.2. PL/Vision Package Bundles
- 4.3.5. Creating the PL/Vision Packages
- 5. PL/Vision Package Specifications
- PLVgen and : 16.4.6. Leveraging PL/Vision in PLVgen
- PLVmsg with : 9.5.1. Using PLVmsg in PL/Vision
- sharing among users : 4.3.6. Granting Access to PL/Vision
- tracing : (see tracing)
- PL/Vision Lite : 4.2. PL/Vision Package Bundles
- placeholder function : 5.9.7. Miscellaneous programs
- plsql procedure
- 5.8.3. Dumping the DDL
- 5.9.6. Executing dynamic PL/SQL
- 19.5.5. Executing Dynamic PL/SQL Code
- plsql_block function
- 5.9.7. Miscellaneous programs
- 19.5.5.1. Implementation of PLVdyn.plsql
- plsql_delimiters constant
- 5.21.1. Package constants
- 10.1.2. Customizing the Delimiter Set
- plsql_identifier variable
- 5.3.2. Anchoring datatypes
- 6.5. The Predefined Datatypes
- 19.5.5.2. Scope of a dynamic PL/SQL block
- plsql_string procedure
- 5.22.3. Parsing PL/SQL source code
- 10.3.2.1. plsql_string procedure
- plug-and-play packages
- 4.2.3. Plug-and-Play Components
- 19. PLVdyn and PLVfk: Dynamic SQL and PL/SQL
- PLV package : 4.2.1. Building Blocks
- constants and functions : 6. PLV: Top-Level Constants and Functions
- PLV_token table : 10.2.1. Keeping Track of PL/SQL Keywords
- PLVcase package
- 4.2.2. Developer Utilities
- 5.4. PLVcase: PL/SQL Code Conversion
- 18.1. PLVcase: Converting the Case of PL/SQL Programs
- PLVcat package
- 4.2.2. Developer Utilities
- 5.5. PLVcat: PL/SQL Code Cataloguing
- 10.3.1. Selecting Token Types for Parsing
- 18.2. PLVcat: Cataloguing PL/SQL Source Code
- references and dependencies : 18.2.4. Identifying References and Dependencies
- plvcat.sql script : 18.2.3.4. Cataloguing PL/Vision
- PLVchar package : 4.2.1. Building Blocks
- PLVchr package : 5.6. PLVchr: Operations on Single Characters
- PLVcmt package
- 4.2.3. Plug-and-Play Components
- 5.7. PLVcmt: Commit Processing
- 20.1. PLVcmt: Enhancing Commit Processing
- 21.1.2.1. Using put_line
- PLVctlg table : 18.2.2. The PLVcat Database Tables
- PLVddd package
- 4.2.2. Developer Utilities
- 5.8. PLVddd: DDL Syntax Dump
- PLVdyn package
- 2.7. Building Windows Into Your Packages
- 4.2.3. Plug-and-Play Components
- 4.4.1. Special Handling for PLVdyn
- 5.9. PLVdyn: Dynamic SQL Operations
- 19.4. PLVdyn: A Code Layer over DBMS_SQL
- compiling code with : 19.4.1.7. Compiling source code with PLVdyn
- displaying table contents : 19.5.7. Displaying a Table
- schemas and : 19.5.10. Executing PLVdyn in Different Schemas
- PLVdyn1 package : 4.2.3. Plug-and-Play Components
- PLVexc package
- 4.2.3. Plug-and-Play Components
- 5.10. PLVexc: Exception Handling
- 16.3.5. Using the PLVexc Exception Handler
- 19.1. About Plug-and-Play
- 21.1.2.1. Using put_line
- 22. Exception Handling
- enhancing with PL/Vision : 22.3.4. Revamping the PLVexc Package
- PLVlog package and : 22.3.4.1. Leveraging PLVLog
- PLVmsg with : 9.5. Integrating PLVmsg with Error Handling
- PLVtrc package and : 22.1.6.5. Integrating PLVexc with PLVtrc
- PLVfile package
- 4.2.1. Building Blocks
- 5.11. PLVfile: Operating System I/O Manager
- 13. PLVfile: Reading and Writing Operating System Files
- PLVfk package
- 4.2.3. Plug-and-Play Components
- 5.12. PLVfk: Foreign Key Interface
- 19.6. PLVfk: Generic Foreign Key Lookups
- PLVgen package
- 2.2. Using Effective Coding Style for Packages
- 2.6.2. Toggles for Code Generation
- 4.2.2. Developer Utilities
- 5.13. PLVgen: PL/SQL Code Generator
- 16. PLVgen: Generating PL/SQL Programs
- overloading in : 16.4.4. Overloading in PLVgen
- plvgrant.sql script : 4.3.6. Granting Access to PL/Vision
- PLVhlp : 4.2.2. Developer Utilities
- PLVhlp package : 5.1. Common Package Elements
- PLVhlp package
- 4.4. Installing Online Help for PL/Vision
- 4.5. Using Online Help
- 5.14. PLVhlp: Online Help Architechture
- 12.1. Why PLVio?
- 16.2.5.1. Generating help text stubs
- 17. PLVhlp: Online Help for PL/SQL Programs
- plvins23.sql script : 4.3.5. Creating the PL/Vision Packages
- plvinst.sql script : 4.3.5. Creating the PL/Vision Packages
- PLVio package
- 4.2.1. Building Blocks
- 5.15. PLVio: Input/Output Processing
- 12. PLVio: Reading and Writing PL/SQL Source Code
- PLVhlp package and : 17.5.5. Constructing an Online Help Package
- PLVlex package
- 4.2.1. Building Blocks
- 5.16. PLVlex: Lexical Analysis
- PLVlog package
- 2.6.3. Changing Package Behavior Without Changing the Application
- 4.2.3. Plug-and-Play Components
- 5.17. PLVlog: Logging Facility
- 21.1. PLVlog: Logging Activity in PL/SQL Programs
- PLVexc package and
- 22.1.7.1. Logging errors
- 22.3.4.1. Leveraging PLVLog
- rollbacks : 21.1.5. Rolling Back with PLVlog
- PLVlst package
- 4.2.1. Building Blocks
- 5.18. PLVlst: List Manager
- PLVmsg package
- 4.2.1. Building Blocks
- 5.19. PLVmsg: Message Handling
- 9. PLVmsg: Single-Sourcing PL/SQL Message Text
- 22.1.6.4. Defining error messages with PLVmsg
- PLVobj package
- 4.2.1. Building Blocks
- 5.20. PLVobj: Object Interface
- 11. PLVobj: A Packaged Interface to ALL_OBJECTS
- PLVprs package
- 4.2.1. Building Blocks
- 5.21. PLVprs: String Parsing
- 10.1. PLVprs: Useful String Parsing Extensions
- PLVprsps : 4.2.1. Building Blocks
- PLVprsps package : 10.3. PLVprsps: Parsing PL/SQL Strings
- plvpsyn.sql script : 4.3.6. Granting Access to PL/Vision
- PLVrb package
- 4.2.3. Plug-and-Play Components
- 5.23. PLVrb: Rollback Processing
- 20.2. PLVrb: Performing Rollbacks
- PLVrfrnc table : 18.2.4.1. Examining the references
- PLVstk package
- 4.2.1. Building Blocks
- 5.24. PLVstk: Stack Manager
- PLVtab package
- 2.6. Building Flexibility Into Your Packages
- 2.8.1.1. Supporting many data combinations
- 4.2.1. Building Blocks
- 5.25. PLVtab: Table Interface
- 8. PLVtab: Easy Access to PL/SQL Tables
- PLVtkn package
- 4.2.1. Building Blocks
- 5.26. PLVtkn: Token Table Interface
- 10.2. PLVtkn: Managing PL/SQL Tokens
- PLVtmr package
- 4.2.2. Developer Utilities
- 5.27. PLVtmr: Program Performance Analyzer
- 14. PLVtmr: Analyzing Program Performance
- 16.2.9. Generating a Timer Script
- 18.2.3.3. Examining the catalogue
- 19.5.5.3. The overhead of dynamic PL/SQL
- PLVtrc package
- 4.2.3. Plug-and-Play Components
- 5.28. PLVtrc: Trace Facility
- 16.3.4. Using the Program Trace
- 21.2. PLVtrc: Tracing Execution of PL/SQL Programs
- PLVexc package and : 22.1.6.5. Integrating PLVexc with PLVtrc
- PLVvu package
- 4.2.2. Developer Utilities
- 5.29. PLVvu: Code and Error Viewing
- 15. PLVvu: Viewing Source Code and Compile Errors
- 17.2. Current Sources of Information
- pop procedure : 5.24.3. Modifying stack contents
- post-insert savepoint : 21.1.5.7. Setting the post-insert savepoint
- pragmas : 1.6.5.1. RESTRICT_REFERENCES pragma
- EXCEPTION_INIT : 5.10.2. Package-based exceptions
- prebuilt packages : 1.5.2. Prebuilt Packages
- predefined exceptions : 22.1.3. Impact of Predefined Exceptions
- prefix table row value : 8.5. Setting the Display Prefix
- prefix function
- 5.2.3. Setting the line prefix
- 5.25.6. Setting the row prefix
- prefixes to package element names : 2.3.3. Avoiding Superfluous Naming Elements
- prependitem procedure : 5.18.3. Modifying list contents
- prevmod function
- 5.28.6. Tracing PL/SQL code execution
- 21.2.4.4. Previous module
- private PL/Vision package synonyms : 4.3.6. Granting Access to PL/Vision
- private elements
- 1.4.4.1. Public and private data
- 2.7. Building Windows Into Your Packages
- 2.10. Hiding Package Data
- declaring before public : 2.2.1. Choosing the Order of Elements
- package elements
- 1.3.1. Enforced Information Hiding
- 1.4.4. Access to Package Elements
- privileges, DDL execution : 19.4.1. DDL Operations
- proc procedure
- 5.13.7. Generating a procedure
- 16.2.2. Generating a Procedure
- 16.4.2. Implementing the Procedure Generator
- procedures : (see functions)
- execute authority : 1.3.5. Guaranteeing Transaction Integrity
- generating
- 16.2.2. Generating a Procedure
- 16.4.2. Implementing the Procedure Generator
- help : 16.2.5.2. Generating a help procedure
- process_halted exception
- 5.10.2. Package-based exceptions
- 22.1.10. Bailing Out with PLVexc
- 22.1.2. Package-Based Exceptions
- productivity : 4.1.1. The Benefits of PL/Vision
- programming technique
- A. Appendix: PL/SQL Exercises
- 1.2.1. The Iceberg Approach to Coding
- 10.1.3.6. numinstr function
- analyzing performance : (see performance)
- avoiding hard-coded literals : 3.12. Obliterating the Literals
- avoiding redundancy : (see redundancy)
- backward compatibility
- 3.3. Supplying Backward Compatibility
- 3.11. Don't Forget Backward Compatibility
- coding packages : 2. Best Practices for Packages
- consistent error data : 22.2.1.1. Recording consistent error data
- cover package : 1.6.4. Working with Large Packages
- declarative programming : 19.2. Declarative Programming in PL/SQL
- handling exceptions : 22.3.1. Analyzing the Need
- handling fatal errors : 22.1.10. Bailing Out with PLVexc
- hard-coded transaction processing : 20.1.1. Who Needs PLVcmt?
- logging : (see logging)
- modularizing : 2.9. Modularizing for Maintainable Packages
- object-oriented design : 1.3.2. Object-Oriented Design
- overloading : 2.8.1. When to Overload
- simultaneous package construction : 2.11. Simultaneous Construction of Multiple Packages
- testing/debugging : 2.6.3.1. The test/debug cycle in PL/SQL
- toggles : 2.6.1. Toggling Package Behavior
- top-down design : 1.3.3. Top-Down Design
- user interface : 3.4. Improving the User Interface
- using package initialization section : 1.6.3.1. When to use the initialization section
- using packages : 1.6.1. When Should You Build a Package?
- windows : 2.7. Building Windows Into Your Packages
- programs : (see code)
- ps2db procedure
- 5.17.6. Managing the log
- 21.1.4.3. Transferring a PL/SQL table log to a database table
- ps_callstack function
- 5.28.5. Accessing the PL/SQL call stack
- 21.2.2. Accessing the PL/SQL Call Stack
- ps_module function
- 5.28.5. Accessing the PL/SQL call stack
- 21.2.2. Accessing the PL/SQL Call Stack
- psformat procedure : 4.1.2. The Origins of PL/Vision
- pstab constant : 5.3.1. PL/Vision constants
- pstab2file procedure
- 5.11.11. Copying a file
- 13.7.4. Copying PL/SQL Table to File
- pstab_count function
- 5.17.6. Managing the log
- 21.1.4.1. Counting and clearing the PL/SQL table
- public PL/Vision package synonyms : 4.3.6. Granting Access to PL/Vision
- public data package elements : 1.4.4. Access to Package Elements
- public elements
- 1.4.4.1. Public and private data
- 2.7. Building Windows Into Your Packages
- 2.10. Hiding Package Data
- 2.10.4. When to Make Data Public
- anchored declarations : 2.10.5. Anchoring to Public Variables
- declaring before private : 2.2.1. Choosing the Order of Elements
- package elements
- 1.3.1. Enforced Information Hiding
- 1.4.1. The Package Specification
- purity levels : 1.6.5.1. RESTRICT_REFERENCES pragma
- push procedure : 5.24.3. Modifying stack contents
- PUT_LINE package
- (see also p package)
- 7. p: A Powerful Substitute for DBMS_OUTPUT
- 5.2. p: a DBMS_OUTPUT Substitute
- put_line procedure
- 5.11.10. Writing to a file
- 5.15.7. Reading and writing lines
- 5.17.4. Writing to the log
- 12.7. Writing to the Target
- 13.6. Writing to a File
- 16.4.3. put_line Procedure
- 21.1.2. Writing to the Log
- specifying rollbacks : 21.1.5.5. Specifying rollbacks when calling put_line
- PUT_LINE procedure : 2.8.1.1. Supporting many data combinations
- put_line repository : 12.7.3. Displaying the Target Repository
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.