Advanced Oracle Pl/Sql: Programming With Packages (Nutshell Handbook)
Advanced Oracle Pl/Sql: Programming With Packages (Nutshell Handbook)
ISBN: B00006AVR6
EAN: N/A
EAN: N/A
Year: 1995
Pages: 195
Pages: 195
Authors: Steven Feuerstein, Debby Russell
- 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
EAN: N/A
Year: 1995
Pages: 195
Pages: 195
Authors: Steven Feuerstein, Debby Russell