Uncovering universal truths
Discovering SQL development rules
Examining PL/SQL development rules
Checking out stored PL/SQL program units
This chapter provides some useful coding standards for PL/SQL developers. Setting and adhering to standards creates a uniform environment that makes it much easier to read and later modify code. Standards can also decrease the cost of the initial development of the code. Well-designed code is easier to write and debug.
Coding standards are as hotly contested a topic as naming conventions. How to capitalize, where to break up lines, and how to comment the code can inspire lively debates within organizations.
This chapter explains the important benefits of standards and provides useful coding standards for PL/SQL developers. Throughout the book, we talk about how to write good code. This chapter summarizes many of the rules and suggestions to help you write code that is easier to read and maintain. Because many of the same standards are applicable in both SQL and PL/SQL contexts, this chapter ...