Tuesday, November 3, 2009

Chapter 21. Oracle Supplied Packages



[ Team LiB ]






Chapter 21. Oracle Supplied Packages



Chapter Objectives



In this Chapter, you will learn to:


Make Use of Oracle Supplied Packages Page



Oracle has built into the Database over 130 packages that extend what you can achieve with PL/SQL. Usually, each new version of the database comes with new supplied packages. Oracle introduced about 17 new packages in each upgrade to versions 9.2 and 10.0. These packages offer functionality that you would not be able to achieve with PL/SQL alone. The reason is that the Oracle Supplied Packages make use of the C programming language; this is not something that you can do with ordinary PL/SQL packages. This means that Oracle Supplied packages have full access to the operating system and other aspects of the Oracle Server that are not available to ordinary PL/SQL packages. You are already familiar with the DBMS_OUTPUT package's procedure PUT_LINE, which is used to gather debugging information into the buffer for output. This chapter serves as an introduction to a few key Oracle Supplied Packages; you will learn their basic features and how to make use of them.






    [ Team LiB ]



    No comments: