Oracle PL/SQL Best Practices

Steven Feuerstein has condensed years of accumulated wisdom and experience into a series of some 120 Oracle PL/SQL Best Practices, these being hints and tips covering a range of topics, all aimed at producing readable and maintainable PL/SQL code, particularly in the context of working in a PL/SQL development team.

While many of the principles involved could apply equally to any structured programming language, Feuerstein addresses the challenges of applying these principles in the PL/SQL programming environment and backs this up with simple code examples.

Some of these best practices are more important that others however Feuerstein identifies the benefits and importance of each best practice and has separately listed the more important (no. 1: "establish and follow clear rules for how to write SQL in your application"--followed by guidelines on how to achieve this).

While this book will probably be of most benefit to the programmer new to PL/SQL, it still contains programming tips and tricks likely to be of use to the experienced PL/SQL programmer too. --Michael O'Connor