Cargando…
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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Sebastopol, Calif. :
O'Reilly Media, Inc.,
2007, ©2008.
|
| Edición: | 2nd ed. |
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
Tabla de Contenidos:
- 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.