Oracle PL/SQL Best Practices

In this book, Steven Feuerstein, a leading expert on Oracle PL/SQL, compiles his extensive experience in programming and teaching into a guide of PL/SQL "best practices" for writing code that is readable, maintainable, and efficient. Many developers prioritize error-free programs but overlook the consequences of poorly written code on system performance and long-term maintainability. This concise reference presents Feuerstein's recommendations for excellent PL/SQL coding, addressing common developer queries such as code formatting, naming conventions, maintainability of packages, efficient database querying, and consistent error handling across teams. The book features 120 best practices organized by topic, offering insights into the program development process, coding style, SQL integration, data structures, control structures, exception handling, and program construction. Additionally, it includes a pull-out quick reference card and provides code examples for each best practice on the O'Reilly website. Serving as a companion to O'Reilly's larger Oracle PL/SQL texts, this compact guide is an essential resource for serious developers, ensuring they have the tools to enhance their coding practices effectively.