tailieunhanh - Oracle Built−in Packages- P1

Oracle Built−in Packages- P1: Ah, for the good old days of Version 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 , 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 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 .