start page | rating of books | rating of authors | reviews | copyrights

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