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

Oracle is the most popular database management system in use today, and PL/SQL plays a pivotal role in current and projected Oracle products and applications. PL/SQL is a programming language providing procedural extensions to the SQL relational database language and to an ever-growing number of oracle development tools. originally a rather limited tool, PL/SQL became with Oracle7 a mature and effective language for developers. now, with the introduction of Oracle8, | 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 Interl0cei.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