|
" Oracle PL/SQL best practices / "
Steven Feuerstein.
Document Type
|
:
|
BL
|
Record Number
|
:
|
1024090
|
Doc. No
|
:
|
b778460
|
Main Entry
|
:
|
Feuerstein, Steven.
|
Title & Author
|
:
|
Oracle PL/SQL best practices /\ Steven Feuerstein.
|
Edition Statement
|
:
|
2nd ed.
|
Publication Statement
|
:
|
Sebastopol, Calif. :: O'Reilly Media, Inc.,, 2007, ©2008.
|
Page. NO
|
:
|
1 online resource (xix, 270 pages) :: illustrations
|
ISBN
|
:
|
0596514107
|
|
:
|
: 9780596514105
|
Bibliographies/Indexes
|
:
|
Includes bibliographical references (pages 252-258) and index.
|
Contents
|
:
|
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.
|
Abstract
|
:
|
"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, packages, triggers; and overall program performance"--Cover.
|
Subject
|
:
|
PL/SQL (Computer program language)
|
Subject
|
:
|
Relational databases.
|
Subject
|
:
|
PL/SQL (Computer program language)
|
Subject
|
:
|
PL/SQL (Computer program language)
|
Subject
|
:
|
Relational databases.
|
Subject
|
:
|
Relational databases.
|
Subject
|
:
|
Oracle (Computer file)
|
|
:
|
Oracle (Computer file)
|
|
:
|
Oracle (Computer file)
|
Dewey Classification
|
:
|
005.7585 O63 FeuO 2008 [ONLINE]
|
LC Classification
|
:
|
QA76.73.S67F487 2008
|
| |