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

Không đóng trình duyệt đến khi xuất hiện nút TẢI XUỐNG Tải xuống

PL/SQL lets you declare local variables and constants and then use those identifiers in your PL/SQL program. You can declare the variables and constants to be a datatype known to the RDBMS, such as NUMBER or VARCHAR2. However, you can also make use of PL/SQL−specific data structures such. | 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