O'Reilly logo

Oracle Database 11g PL/SQL Programming Workbook by John M. Harper, Michael McLaughlin

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 8Packages

You can find PL/SQL in many Oracle products including PeopleSoft, Oracle Forms 11g, Oracle Database 11g, Oracle Application Server, Oracle Application Express, and Oracle E-Business Suite. For example, a typical database contains at least 300 thousand lines of PL/SQL. Furthermore, the E-Business Suite contains more than 20 million. What’s more, Oracle built-in packages continue to increase with each major release of the database engine. PL/SQL is definitely not going away, and mastering package design and implementation is essential to your success as a DBA, data architect, or database developer.

This chapter shows you how to design and build packages that take full advantage of the Oracle PL/SQL feature set. We divide it into ...

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