Oracle PL/SQL best practices
"This book summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the sue of SQL in PL/SQL; building procedures, functions, p...
| Main Author: | |
|---|---|
| Format: | eBook |
| Language: | English |
| Published: |
Sebastopol, Calif.
O'Reilly Media, Inc.
2007
|
| Edition: | 2nd ed |
| Subjects: | |
| Online Access: | |
| Collection: | O'Reilly - Collection details see MPG.ReNa |
Table of Contents:
- Includes bibliographical references (pages 252-258) and index
- 1. The Big Picture
- Successful Applications Are Never an Accident
- Best Practices for Successful Applications
- 2. Real Developers Follow Standards
- Best Practices for Developing and Using Standards
- 3. Life After Compilation
- Testing, Tracing, and Debugging
- Best Practices for Testing, Tracing, and Debugging
- 4. What's Code Without Variables?
- Best Practices for Declaring Variables and Data Structures
- Best Practices for Using Variables and Data Structures
- Best Practices for Declaring and Using Package Variables
- 5. Developer As Traffic Cop
- Best Practices for Conditional and Boolean Logic
- Best Practices for Loop Processing
- Best Practices for Branching Logic
- 6. Doing the Right Thing When Stuff Goes Wrong
- Best Practices for Understanding Error Handling
- Best Practices for Nitty-Gritty, Everyday Exception Programming
- Best Practices for Coding Defensively
- 7. Break Your Addiction to SQL
- SQL is Bad!
- General SQL Best Practices
- Best Practices for Querying Data from PL/SQL
- Best Practices for Changing Data from PL/SQL
- Best Practices for Dynamic SQL
- 8. Playing with Blocks (of Code)
- Best Practices for Parameters
- Best Practices for Procedures and Functions
- Best Practices for Packages
- Best Practices for Triggers
- 9. My Code Runs Faster Than Your Code
- Best Practices for Finding Slow Code
- Best Practices for High-Impact Tuning
- Best Practices for Other Tuning
- A. Best Practices Quick Reference
- B. Resources for PL/SQL Developers