Ships from: Springfield, VA
Usually ships in 1-2 business days
Ships from: acton, MA
Usually ships in 1-2 business days
Want a NOOK? Explore Now
In this book, Steven Feuerstein, widely recognized as one of the world's experts on the Oracle PL/SQL language, distills his many years of programming, writing, and teaching about PL/SQL into a set of PL/SQL language "best practices"—rules for writing code that is readable, maintainable, and efficient. Too often, developers focus on simply writing programs that run without errors—and ignore the impact of poorly written code upon both system performance and their ability (and their colleagues' ability) to maintain that code over time.Oracle PL/SQL Best Practices is a concise, easy-to-use reference to Feuerstein's recommendations for excellent PL/SQL coding. It answers the kinds of questions PL/SQL developers most frequently ask about their code:
Dedication;
Preface;
Structure of This Book;
How to Use This Book;
Not All Best Practices Are Created Equal;
About the Code;
Other Resources;
Conventions Used in This Book;
Comments and Questions;
Acknowledgments;
Chapter 1: The Development Process;
Chapter 2: Coding Style and Conventions;
Chapter 3: Variables and Data Structures;
3.1 Declaring Variables and Data Structures;
3.2 Using Variables and Data Structures;
3.3 Declaring and Using Package Variables;
Chapter 4: Control Structures;
4.1 Conditional and Boolean Logic;
4.2 Loop Processing;
4.3 Miscellaneous;
Chapter 5: Exception Handling;
5.1 EXC-00: Set guidelines for application-wide error handling before you start coding.;
5.1 Raising Exceptions;
5.2 Handling Exceptions;
5.3 Declaring Exceptions;
Chapter 6: Writing SQL in PL/SQL;
6.1 SQL-00: Establish and follow clear rules for how to write SQL in your application.;
6.1 General SQL and Transaction Management;
6.2 Querying Data from PL/SQL;
6.3 Changing Data from PL/SQL;
6.4 Dynamic SQL and Dynamic PL/SQL;
Chapter 7: Program Construction;
7.1 Structure and Parameters;
7.2 Functions;
7.3 Triggers;
Chapter 8: Package Construction;
Chapter 9: Built-in Packages;
9.1 DBMS_OUTPUT;
9.2 UTL_FILE;
9.3 DBMS_PIPE;
9.4 DBMS_ JOB;
Appendix A: Best Practices Quick Reference;
A.1 The Development Process;
A.2 Coding Style and Conventions;
A.3 Variables and Data Structures;
A.4 Control Structures;
A.5 Exception Handling;
A.6 Writing SQL in PL/SQL;
A.7 Program Construction;
A.8 Package Construction;
A.9 Built-in Packages;
Colophon;
Overview
In this book, Steven Feuerstein, widely recognized as one of the world's experts on the Oracle PL/SQL language, distills his many years of programming, writing, and teaching about PL/SQL into a set of PL/SQL language "best practices"—rules for writing code that is readable, maintainable, and efficient. Too often, developers focus on simply writing programs that run without errors—and ignore the impact of poorly written code upon both system performance and their ability (and their colleagues' ability) to maintain...