Packages and Types Reference

Oracle supplies many PL/SQL packages with the Oracle server to extend databasefunctionality and provide PL/SQL access to SQL features. You can use the suppliedpackages when creating your applications or for ideas in creating your own storedprocedures.
Nội dung trích xuất từ tài liệu:
Packages and Types ReferencePL/SQLPackages and Types Reference10g Release 1 (10.1)Part No. B10802-01December 2003PL/SQL Packages and Types Reference, 10g Release 1 (10.1)Part No. B10802-01Copyright © 1998, 2003 Oracle Corporation. All rights reserved.Primary Author: Den RaphaelyContributing Authors: Gina Abeles, Cathy Baird, Deanna Bradshaw, Craig Foch, Laurel Hale, Paul Lane,Jeff Levinger, Roza Leyderman, Chuck Murray, Eric Paapanen, Kathy Rich, Vivian Schupmann, IngridStuart, Randy UrbanoContributors: Ted Burroughs, Shelley, Higgins, Jennifer Polk, Colin McGregor, Chuck Murray, RichardSmithGraphics Production Specialist: Valarie MooreThe Programs (which include both the software and documentation) contain proprietary information ofOracle; they are provided under a license agreement containing restrictions on use and disclosure andare also protected by copyright, patent and other intellectual and industrial property laws. Reverseengineering, disassembly or decompilation of the Programs, except to the extent required to obtaininteroperability with other independently created software or as specified by law, is prohibited.The information contained in this document is subject to change without notice. If you find any problemsin the documentation, please report them to us in writing. Oracle does not warrant that this document iserror-free. Except as may be expressly permitted in your license agreement for these Programs, no part ofthese Programs may be reproduced or transmitted in any form or by any means, electronic ormechanical, for any purpose, without the express written permission of Oracle.If the Programs are delivered to the U.S. Government or anyone licensing or using the programs onbehalf of the U.S. Government, the following notice is applicable:Restricted Rights Notice Programs delivered subject to the DOD FAR Supplement are commercialcomputer software and use, duplication, and disclosure of the Programs, including documentation,shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement.Otherwise, Programs delivered subject to the Federal Acquisition Regulations are restricted computersoftware and use, duplication, and disclosure of the Programs shall be subject to the restrictions in FAR52.227-19, Commercial Computer Software - Restricted Rights (June, 1987). Oracle, 500 Oracle Parkway,Redwood City, CA 94065.The Programs are not intended for use in any nuclear, aviation, mass transit, medical, or other inherentlydangerous applications. It shall be the licensees responsibility to take all appropriate fail-safe, backup,redundancy, and other measures to ensure the safe use of such applications if the Programs are used forsuch purposes, and Oracle disclaims liability for any damages caused by such use of the Programs.Oracle is a registered trademark, and ConText, Oracle Store, Oracle7, Oracle8, Oracle8i, Oracle9i,PL/SQL, Pro*C, and SQL*Plus are trademarks or registered trademarks of Oracle Corporation. Othernames may be trademarks of their respective owners. ContentsSend Us Your Comments ................................................................................................................ xxvPreface....................................................................................................................................................... xxvii Audience ........................................................................................................................................... xxviii Organization..................................................................................................................................... xxviii Related Documentation .................................................................................................................. xxviii Conventions........................................................................................................................................ xxix Documentation Accessibility ........................................................................................................... xxxiWhats New in PL/SQL Packages and Types Reference? ........................................ xxxiii Oracle Database 10g Release 1 (10.1) New Features ................................................................... xxxiv Oracle9i Release 2 (9.2) New Features ................................................................................................ xl Oracle9i Release 1 (9.0.1) New Features ........................................................................................... xlii Oracle8i Release 2 (8.1.6) New Features ......................................... ...