Đang chuẩn bị liên kết để tải về tài liệu:
Oracle Built−in Packages- P1

Oracle Built−in Packages- P1: 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 Appendix A What s on the Companion Disk Table of Contents A. What s on the Companion Disk .2 A.1 Installing the Guide.2 .3 A.2 Using the Guide.3 .4 1. Introduction.5 1.1 The Power of Built-in Packages.5 1.1.1 A Kinder More Sharing Oracle.6 .7 1.2 Built-in Packages Covered in This Book.7 1.2.1 Application Development Packages.10 1.2.2 Server Management Packages.11 1.2.3 Distributed Database Packages.12 .14 1.3 Using Built-in Packages.14 1.3.1 What Is a Package .14 1.3.2 Controlling Access with Packages.15 1.3.3 Referencing Built-in Package Elements.17 1.3.4 Exception Handling and Built-in Packages.18 1.3.5 Encapsulating Access to the Built-in Packages.24 1.3.6 Calling Built-in Packaged Code from Oracle Developer 2000 Release 1.27 1.3.7 Accessing Built-in Packaged Technology from Within SQL.30 .38 1.4 Examining Built-in Package Source Code .38 1.4.1 The STANDARD Package.39 1.4.2 The DBMS_STANDARD Package.40 .42 2. Executing Dynamic SQL and PL SQL.43 2.1 Examples of Dynamic SQL.43 .46 2.2 Getting Started with DBMS_SQL.46 2.2.1 Creating the DBMS_SQL Package.46 2.2.2 Security and Privilege Issues.46 2.2.3 DBMS_SQL Programs.46 2.2.4 Types of Dynamic SQL.47 2.2.5 DBMS_SQL Exception s.49 2.2.6 DBMS_SQL Nonprogram Elements.49 .52 2.3 The DBMS_SQL Interface.52 2.3.1 Processing Flow of Dynamic SQL.52 2.3.2 Opening the Cursor.54 2.3.3 Parsing the SQL Statement.55 2.3.4 Binding Values into Dynamic SQL.58 2.3.5 Defining Cursor Columns.63 2.3.6 Executing the Cursor.66 2.3.7 Fetching Rows.66 2.3.8 Retrieving Values.69 2.3.9 Closing the Cursor.76 2.3.10 Checking Cursor Status.77 2.3.11 Describing Cursor Columns.80 .85i Appendix A What s on the Companion Disk Table of Contents 2.4 Tips on Using Dynamic SQL.85 2.4.1 Some Restrictions.85 2.4.2 Privileges and Execution Authority with DBMS_SQL.85 2.4.3 Combining Operations .87 2.4.4 Minimizing Memory for Cursors.88 2.4.5 Improving the Performance of Dynamic SQL.89 2.4.6 Problem-Solving Dynamic .