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 14

PL/SQL Best Practices

In This Chapter

bullet Understanding why best practices are important

bullet Becoming a good PL/SQL programmer

bullet Following the code-writing process

bullet Testing your code

Many people believe that being a good PL/SQL programmer means knowing all about the latest features, obscure syntax for commands in the packages, VARRAYs, object collections, and so on. Knowing all these things means that you’re knowledgeable about the PL/SQL language, but it doesn’t make you a good PL/SQL programmer.

Well-written code executes within a reasonable period of time, provides good performance, and is bug-free whenever possible. But even more important, the code is structured in such a way that you can be assured that it does what it is supposed to do, and when modifications are necessary, you can easily see where they are needed. To help you create code that meets these goals, this chapter discusses some important best practices to keep in mind when programming in PL/SQL. These best practices are taken from our experiences in building real systems.

Why Are Best Practices Important? ...

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