Oracle PL/SQL For Dummies

Chapter 9

Creating Coding Standards

In This Chapter

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 ...