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...

Full description

Bibliographic Details
Main Author: Feuerstein, Steven
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
LEADER 03497nmm a2200409 u 4500
001 EB001937980
003 EBX01000000000000001100882
005 00000000000000.0
007 cr|||||||||||||||||||||
008 210123 ||| eng
020 |a 9780596514105 
050 4 |a QA76.73.S67 
100 1 |a Feuerstein, Steven 
245 0 0 |a Oracle PL/SQL best practices  |c Steven Feuerstein 
250 |a 2nd ed 
260 |a Sebastopol, Calif.  |b O'Reilly Media, Inc.  |c 2007 
300 |a xix, 270 pages  |b illustrations 
505 0 |a Includes bibliographical references (pages 252-258) and index 
505 0 |a 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 
653 |a Oracle (Computer file) / http://id.loc.gov/authorities/names/n91015760 
653 |a Oracle (Computer file) / blmlsh 
653 |a Bases de données relationnelles 
653 |a PL/SQL (Langage de programmation) 
653 |a PL/SQL (Computer program language) / fast / (OCoLC)fst01049863 
653 |a Relational databases / blmlsh 
653 |a Relational databases / http://id.loc.gov/authorities/subjects/sh86007768 
653 |a Relational databases / fast / (OCoLC)fst01093575 
653 |a Oracle (Computer file) / fast / (OCoLC)fst01363816 
653 |a PL/SQL (Computer program language) / http://id.loc.gov/authorities/subjects/sh96008008 
653 |a PL/SQL (Computer program language) / blmlsh 
041 0 7 |a eng  |2 ISO 639-2 
989 |b OREILLY  |a O'Reilly 
776 |z 0596514107 
776 |z 9780596514105 
856 4 0 |u https://learning.oreilly.com/library/view/~/9780596514105/?ar  |x Verlag  |3 Volltext 
082 0 |a 005.7585 O63 FeuO 2008 [ONLINE] 
520 |a "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