Flylib.com
Advanced Oracle Pl/Sql: Programming With Packages (Nutshell Handbook)
Advanced Oracle Pl/Sql: Programming With Packages (Nutshell Handbook)
ISBN: B00006AVR6
EAN: N/A
Year: 1995
Pages: 195
Authors:
Steven Feuerstein
,
Debby Russell
BUY ON AMAZON
Cover
Table of Contents
Dedication
Forward
Preface
Structure of This Book
Conventions Used in This Book
About the Disk
About PLVision
Comments and Questions
Acknowledgments
Part I - Working with Packages
Chapter 1 - PLSQL Packages
1.2 What Are the Types and Layers of Packages?
1.3 What Are the Benefits of Packages?
1.4 Using Packages
1.5 Types of Packages
1.6 Building Packages
Chapter 2 - Best Practices for Packages
2.2 Using Effective Coding Sytle for Packages
2.3 Selecting Package Names
2.4 Organizing Package Source Code
2.5 Constructing fthe Optimal Interface to Your Package
2.6 Building Flexibility Into Your Packages
2.7 Building Windows Into Your Packages
2.8 Overloading for Smart Packages
2.9 Modularizing for Maintainable Packages
2.10 Hiding Package Data
Chapter 3 - The PLSQL Development Spiral
3.2 Adding Value
3.3 Supplying Backward Compatibility
3.4 Improving the User Interface
3.5 Rough Waters Ahead
3.6 Building a Structured Function
3.7 Handling Program Assumptions
3.8 Broadening the Scope
3.9 Considering Implementation Options
3.10 Choosing the Best Performer
3.11 Don t Forget Backward Compatibility
3.12 Obliterating the Literals
3.13 Glancing Backward, Looking Upward
Part II - PLVision Overview
Chapter 4 - Getting Started with PLVision
4.2 PLVision Package Bundles
4.3 Installation Instructions
4.4 Installing Online Help for PLVision
4.5 Using Online Help
4.6 Summary of Files on Disk
Chapter 5 - PLVision Packages Specifications
5.2 p: a DBMS_OUTPUT Substitute
5.3 PLV: Top-Level Constants and Functions
5.4 PLVcase: PLSQL Code Conversion
5.5 PLVcat: PLSQL Code Cataloguing
5.6 PLVchr: Operations and Single Characters
5.7 PLVcmt: Commit Processing
5.8 PLVddd: DDL Syntax Dump
5.9 PLVdyn: Dynamic SQL Operations
5.10 PLVexc: Exception Handling
5.11 PLVfile: Operating System IO Manager
5.12 PLVfk: Foreign Key Interface
5.13 PLVgen: PLSQL Code Generator
5.14 PLVhlp: Online Help Architecture
5.15 PLVio: InputOutput Processing
5.16 PLVlex: Lexical Analysis
5.17 PLVlog: Logging Facility
5.18 PLVlst: List Manager
5.19 PLVmsg: Message Handling
5.20 PLVobj: Object Interface
5.21 PLVprs: String Parsing
5.22 PLVprsps: PLSQL Source Code Parsing
5.23 PLVrb: Rollback Processing
5.24 PLVstk: Stack Manager
5.25 PLVtab: Table Interface
5.26 PLVtkn: Token Table Interface
5.27 PLVtmr: Program Performance Analyzer
5.28 PLVtrc: Trace Facility
5.29 PLVvu: Code and Error Viewing
Part III - Building Block Packages
Chapter 6 - PLV: Top-Level Constants and Functions
6.2 Setting the PLVision Date Mask
6.3 Assertion Routines
6.4 PLV Utilities
6.5 The Predefined Datatypes
6.6 The Predefined Constants
Chapter 7 - p: A Powerful Substitute for DBMS_OUTPUT
7.2 The Line Seperator
7.3 The Output Prefix
7.4 Controlling Output from p
Chapter 8 - PLVtab: Easy Access to PLSQL Tables
8.2 Displaying PLVtab Tables
8.3 Showing Header Toggle
8.4 Showing Row Number Toggle
8.5 Setting the Display Prefix
8.6 Emptying Tables with PLVtab
8.7 Implementing PLVtab.display
Chapter 9 - PLVmsg: Single-Sourcing PLSQL Message Text
9.2 Storing Message Text
9.3 Retrieving Message Text
9.4 The Restriction Toggle
9.5 Integrating PLVmsg with Error Handling
9.6 Implementing load_from_dbms
Chapter 10 - PLVprs, PLVtkn, and PLVprsps: Parsing String
10.2 PLVtkn: Manging PLSQL Tokens
10.3 PLVprsps: Parsing PLSQL Strings
Chapter 11 - PLVobj: A Packaged Interface to ALL_OBJECTS
11.2 ALL_OBJECTS View
11.3 Setting the Current Object
11.4 Accessing ALL_OBJECTS
11.5 Binding Objects to a Dynamic Cursor
11.6 Populating a PLSQL Table with Object Names
11.7 A Programmatic Cursor FOR Loop
11.8 Tracing PLVobj Activity
Chapter 12 - PLVio: Reading and Writing PLSQL Source Code
12.2 Code Repositories Supported by PLVio
12.3 Managing the Source Repository
12.4 The Source WHERE Clause
12.5 Managing the Target Repository
12.6 Reading From the Source
12.7 Writing to the Target
12.8 Saving and Restoring Settings
12.9 Cleaning Up Source and Target
Chapter 13 - PLVfile: Reading and Writing Operating System Files
13.2 Specifying the File in PLVfile
13.3 Creating and Checking Existence of Files
13.4 Opening and Closing Files
13.5 Reading From a File
13.6 Writing to a File
13.7 Copying File Contents
13.8 Displaying File Contents
13.9 Handling File Errors with PLVfile
13.10 Tracing PLVfile Activity
Part IV - Developer Uitility Packages
Chapter 14 - PLVtmr: Analyzing Program Performance
14.2 Capturing the Start Time
14.3 Retrieving and Displaying the Elapsed Time
14.4 Using PLVtmr in Scripts
Chapter 15 - PLVvu: Viewing Source Code and Compile Errors
15.2 Displaying Compile Errors
15.3 Displaying Source Code
15.4 Implementing PLVvu
Chapter 16 - PLVgen: Generating PLSQL Programs
16.2 Code Generated by PLVgen
16.3 Modifying PLVgen Behavior
16.4 Implementing PLVgen
Chapter 17 - PLVhlp: Online Hilp for PLSQL Programs
17.2 Current Sources of Information
17.3 What Is Online Help for Stored Code?
17.4 Using PLVhlp
17.5 Implementing PLVhlp
Chapter 18 - PLVcase and PLvcat: Converting and Analyzing PLSQL Code
18.2 PLVcat: Cataloguing PLSQL Source Code
Part V - Plug-and-Play Packages
Chapter 19 - PLVdyn and PLVfk: Dynamic SQL and PLSQL
19.2 Declarative Programming in PLSQL
19.3 The Dynamic Packages of PLVision
19.4 PLVdyn: A Code Layer over DBMS_SQL
19.5 DML Operations
19.6 PLVfk: Generic Foreign Key Lookups
Chapter 20 - PLVcmt and PLVrb: Commit and Rollback Processing
20.2 PLVrb: Performing Rollbacks
Chapter 21 - PLVlog and PLVtrc: Logging and Tracing
21.2 PLVtrc: Tracing Execution of PLSQL Programs
Chapter 22 - Exception Handling
22.2 Application-Specific Exception Packages
22.3 Implementing PLVexc
Part VI - Testing Your Knowledge
Appendix A - PLSQL Exercises
A.2 Solutions
Symbols and Numbers
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
Y
Z
Advanced Oracle Pl/Sql: Programming With Packages (Nutshell Handbook)
ISBN: B00006AVR6
EAN: N/A
Year: 1995
Pages: 195
Authors:
Steven Feuerstein
,
Debby Russell
BUY ON AMAZON
Agile Project Management: Creating Innovative Products (2nd Edition)
Phase: Envision
Practice: Get the Right People
Phase: Adapt
Team Self-Discipline
The Commitment-Accountability Protocol
Metrics and Models in Software Quality Engineering (2nd Edition)
Scatter Diagram
Satisfaction with Company
A Proposed Software Project Assessment Method
Data Quality Control
A Project Assessment Questionnaire
Software Configuration Management
Appendix I System Service Request
Appendix L Software Requirements Changes
Appendix M Problem Report (PR)
Appendix X SCM Guidance for Achieving the Repeatable Level on the Software
Appendix Y Supplier CM Market Analysis Questionnaire
Excel Scientific and Engineering Cookbook (Cookbooks (OReilly))
Exploring VBAs Built-in Functions
Annotating Charts
Tackling Troublesome Problems
Doubling Your Money
Achieving a Certain Future Value
Google Maps Hacks: Tips & Tools for Geographic Searching and Remixing
Hack 3. Navigate the World in Your Web Browser
Hack 14. Create Custom Map Markers
Hack 20. Track Official Storm Reporting
Hack 22. Witness the Effects of a Nuclear Explosion
Hack 69. Cluster Markers at High Zoom Levels
HTI+ Home Technology Integrator & CEDIA Installer I All-In-One Exam Guide
Planning a Structured Wiring Installation
Designing and Installing a Computer Network
Designing and Installing a Home Telephone System
Home Automation Controllers
Appendix A Home Technology Project Management
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies