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 15

Ten PL/SQL Tips

In This Chapter

bullet Using SELECT INTO with exception handling

bullet Listing columns explicitly in DML statement

bullet Using the NOCOPY hint for IN OUT parameters

bullet Making efficient function calls

bullet Using DDL commits

bullet Limiting functions to one return statement

bullet Passing parameters

bullet Debugging with WHEN OTHERS in the right way

bullet Knowing when to use implicit and explicit cursors

bullet Working with dates as numbers

Experienced PL/SQL developers can give you hundreds of tips based on their programming ...

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