Đang chuẩn bị nút TẢI XUỐNG, xin hãy chờ
Tải xuống
Oracle Built−in Packages- P2: Ah, for the good old days of Version 1.0 of PL /SQL! Life was so simple then. No stored procedures or functions and certainly no packages. You had your set of built−in functions, like SUBSTR and TO_DATE. You had the IF statement and various kinds of loops. With these tools at hand, you built your batch−processing scripts for execution in SQL*Plus, and you coded your triggers in SQL*Forms 3.0, and you went home at night content with a good day's work done. | Appendix A What s on the Companion Disk Table of Contents 8. Managing Large Objects 8.1.3 DBMS_LOB Nonprogram Elements.392 8.1.4 About the Examples.392 .395 8.2 LOB Concepts.395 8.2.1 LOB Datatypes.395 8.2.2 BFILE Considerations.398 8.2.3 Internal LOB Considerations.399 .402 8.3 DBMS_LOB Interface.402 8.3.1 Working with BFILEs.402 8.3.2 Reading and Examining LOBs.415 8.3.3 Updating BLOBs CLOBs and NCLOBs.424 .433 9. Datatype Packages.434 9.1 DBMS_ROWID Working with the ROWID Pseudo-Column Oracle8 only .434 9.1.1 Getting Started with DBMS_ROWID.434 9.1.2 ROWID Concepts .436 9.1.3 The DBMS_ROWID Interface.437 .444 9.2 UTL_RAW Manipulating Raw Data.444 9.2.1 Getting Started with UTL_RAW.444 9.2.2 Raw Data Manipulation Concepts.446 9.2.3 The UTL_RAW Interface.447 9.2.4 UTL_REF Referencing Objects Oracle8.0.4 .463 9.2.5 UTL_REF Interface.465 9.2.6 UTL_REF Example.468 .471 10. Miscellaneous Packages.472 10.1 DBMS_UTILITY Performing Miscellaneous Operations.472 10.1.1 Getting Started with DBMS_UTILITY.472 10.1.2 The DBMS_UTILITY Interface.475 .493 10.2 DBMS_DESCRIBE Describing PL SQL Program Headers .493 10.2.1 Getting Started with DBMS_DESCRIBE.493 10.2.2 Explaining DBMS_DESCRIBE Results.496 10.2.3 DBMS_DESCRIBE Example.499 .504 10.3 DBMS_DDL Compiling and Analyzing Objects.504 10.3.1 Getting Started with DBMS_DDL.504 10.3.2 Compiling PL SQL Objects.505 10.3.3 Computing Statistics for an Object .508 10.3.4 Setting Referenceability of Tables.510 .514 10.4 DBMS_RANDOM Generating Random Numbers Oracle8 Only .514 10.4.1 Getting Started with DBMS_RANDOM.514 10.4.2 DBMS_RANDOM Interface.515 51 v Appendix A What s on the Companion Disk Table of Contents 11. Managing Session Information.518 11.1 DBMS_SESSION Managing Session Information.518 11.1.1 Getting Started with DBMS_SESSION.518 11.1.2 Modifying Session Settings.519 11.1.3 Obtaining Session Information.523 11.1.4 Managing Session Resources.525 11.1.5 DBMS_SESSION Examples.530 .540 11.2 DBMS_System Setting Events for .