tailieunhanh - 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 Installing the .3 Using the .4 1. The Power of Built-in A Kinder More Sharing .7 Built-in Packages Covered in This Application Development Server Management Distributed Database .14 Using Built-in What Is a Package .14 Controlling Access with Referencing Built-in Package Exception Handling and Built-in Encapsulating Access to the Built-in Calling Built-in Packaged Code from Oracle Developer 2000 Release Accessing Built-in Packaged Technology from Within . 38 Examining Built-in Package Source Code .38 The STANDARD The DBMS_STANDArD .42 2. Executing Dynamic SQL and PL Examples of Dynamic . 46 Getting Started with Creating the DBMS_SQL Security and Privilege DBMS_SQL Types of Dynamic DBMS_SQL Exception DBMS_SQL Nonprogram .52 The DBMS_SQL Processing Flow of Dynamic Opening the Parsing the SQL Binding Values into Dynamic Defining Cursor Executing the Fetching Retrieving Closing the Checking Cursor Describing Cursor .85i Appendix A What s on the Companion Disk Table of Contents Tips on Using Dynamic Some Privileges and Execution Authority with Combining Operations .87 Minimizing Memory for Improving the Performance of Dynamic Problem-Solving Dynamic