Đang chuẩn bị liên kết để tải về tài liệu:
Oracle PL/SQL Programming

In a Microsoft Windows environment, you begin installation by double−clicking on the setup.exe file to run the installation program. If you are working in a non−Windows environment, please visit the RevealNet PL/SQL Pipeline Archives (http://www.revealnet.com/plsql−pipeline) to obtain a compressed file containing the utilities on this disk. The installation script will lead you through the necessary steps. The first screen you will see is the install screen shown in Figure A.1. | 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 .5 B. Calling Stored Procedures from PL SQL Version 1.1.6 B. 1 Using Stubs to Talk to Server-Side PL SQL.7 .9 B. 2 Restrictions on Calling Stored Procedures.9 B.2.1 No Server-Side PL SQL Datatypes.9 B.2.2 No Direct Stored Package Variable References.10 B.2.3 No Direct Remote Procedure Calls.12 B. 2.4 No Default Parameter Values.12 .14 C. Built-In Packages.15 C. 1 Using the Built-in Packages.16 .18 C.2 DBMS_ALERT.18 C. 2.1 The REGISTER procedure.18 C.2.2 The REMOVE procedure .18 C.2.3 The REMOVEALL procedure.18 C.2.4 The SET_DEFAULTS procedure.18 C.2.5 The SIGNAL procedure.18 C.2.6 The WAITANY procedure.19 C.2.7 The WAITONE procedure.19 .20 C.3 Oracle AQ the Advanced Queueing Facility.20 C.3.1 DBMS_AQ PL SQL 8 Only .20 C.3.2 DBMS_AQADM PL SQL 8 Only .21 .24 C.4 DBMS_DDL.24 C.4.1 The ALTER_COMPILE procedure.24 C.4.2 The ANALYZE_OBJECT procedure.24 .25 C.5 DBMS_ JOB.25 C.5.1 The BROKEN procedure.25 C.5.2 The CHANGE procedure.25 C.5.3 The INTERVAL procedure.25 C.5.4 The ISUBMIT procedure.25 C.5.5 The NEXT_DATE procedure.26 C.5.6 The REMOVE procedure.26 C.5.7 The RUN procedure.26 C.5.8 The SUBMIT procedure.26 C.5.9 The USER_EXPORT procedure.26 C.5.10 The WHAT procedure.26 .28 C.6 DBMS_LOB PL SQL8 Only .28 C.6.1 The APPEND procedure.28 C.6.2 The COMPARE function.28 C.6.3 The COPY procedure.29 i Appendix A What s on the Companion Disk Table of Contents C.6.4 The ERASE procedure.29 C.6.5 The FILECLOSE procedure.29 C.6.6 The FILECLOSEALL procedure.29 C.6.7 The FILEEXISTS function.29 C.6.8 The FILEGETNAME procedure .29 C.6.9 The FILEISOPEN function.30 C.6.10 The FILEOPEN procedure.30 C.6.11 The GETLENGTH function.30 C.6.12 The INSTR function.30 C.6.13 The READ procedure.30 C.6.14 The SUBSTR function.31 C.6.15 The TRIM procedure.31 C.6.16 The WRITE procedure.31 .33 C.7 DBMS_LOCK.33 C.7.1 The