O'Reilly logo

Oracle PL/SQL For Dummies by Paul Dorsey, Michael Rosenblum

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9

Creating Coding Standards

In This Chapter

bullet Uncovering universal truths

bullet Discovering SQL development rules

bullet Examining PL/SQL development rules

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required