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.



Oracle PL[s]SQL by Example
Oracle PL[s]SQL by Example
ISBN: 3642256902
EAN: N/A
Year: 2003
Pages: 289

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net