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 ...
Get Oracle Database 11g PL/SQL Programming Workbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.