Optimizing Oracle Code
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:
How should I format my code?
What naming conventions, if any, should I use?
How can I write my packages so they can be more easily maintained?
What is the most efficient way to query...