开发工具:
文件大小: 1mb
下载次数: 0
上传时间: 2008-10-03
详细说明： Oracle触发器与存储过程高级编程。 Chapter One. An Introduction to Relational Database Tables Section 1.1. Before Relational Tables Section 1.2. SQL Section 1.3. Tables Section 1.4. SQL Statements Section 1.5. Table Column Datatypes Section 1.6. Behind Tables Chapter Two. Interacting with Oracle Section 2.1. Simplify SQL*Plus for Yourself on Windows Section 2.2. Connecting Section 2.3. Connecting to an Infrastructure Section 2 .4. Disconnecting Section 2.5. Command Line Section 2.6. Changes on the Command Line Section 2.7. Scripts Section 2.8. Script Output Section 2.9. Command Line Arguments Section 2.10. SQL*Plus with Korn Shell Section 2.11. Batch Command Files Section 2.12. SQL*Plus with Active State Perl Section 2.13. Privileges Section 2.14. DUAL Section 2.15. Autotrace Chapter Three. Declarative Constraints Section 3.1. Primary Key Section 3.2. UNIQUE Section 3.3. Foreign Key Section 3.4. Check Section 3.5. NOT NULL Constraints Section 3.6. Default Values Section 3.7. Modifying Constraints Section 3.8. Exception Handling Section 3.9. Data Loads Chapter Four. A Data Model with Constraints Section 4.1. Entity Relationship Diagram Section 4.2. Table Descriptions Section 4.3. DDL Section 4.4. Sample Data Chapter Five. Viewing Constraints in the Data Dictionary Section 5.1. What You Can See Section 5.2. Dictionary Views: An Overview Section 5.3. Constraint Views Section 5.4. USER_CONS_COLUMNS Section 5.5. USER_CONSTRAINTS Section 5.6. Data Dictionary Constraint Scripts Chapter Six. Row Trigger Mechanics Section 6.1. Introduction Section 6.2. Before versus After Section 6.3. Insert Row Trigger Syntax Section 6.4. Trigger Body Section 6.5. Example Row Triggers Section 6.6. A Table with Oracle Constraints and Business Rules Chapter Seven. Statement Level Triggers Section 7.1. Sequence of Events Section 7.2. Insert Statement Trigger Syntax Section 7.3. Statement Level Aggregation Section 7.4. Processing Row Captured Data Chapter Eight. Complex Rule Enforcement Chapter Nine. The PL/SQL Environment Section 9.1. A Hello World Program Section 9.2. Referencing Oracle Packages Section 9.3. USER_OBJECTS Section 9.4. Dependencies among Procedures Section 9.5. USER_DEPENDENCIES Section 9.6. USER_SOURCE Section 9.7. Sharing Code Section 9.8. Compilation Dependency Section 9.9. USER_ERRORS Chapter Ten. PL/SQL Program Units Section 10.1. Procedures Section 10.2. Functions Section 10.3. Subprogram Encapsulation: Introduction to Packages Section 10.4. Package Specification Section 10.5. Package Body Section 10.6. Application Partitioning Section 10.7. Data Abstraction Section 10.8. Parameters and Modes Section 10.9. Overloading Chapter Eleven. PL/SQL Language Features Section 11.1. Comments Section 11.2. Assignments and Statements Section 11.3. Boolean Expression Section 11.4. Expressions with NULL Section 11.5. Logical Operators Section 11.6. String Concatenation Section 11.7. Arithmetic Expressions Section 11.8. Variable Declarations Section 11.9. Types Section 11.10. IF Statement Section 11.11. CASE Statement Section 11.12. LOOP Section 11.13. STRING Manipulation Functions Section 11.14. Miscellaneous String Functions Section 11.15. Numeric Functions Section 11.16. Random Number Generation Section 11.17. Date Functions Section 11.18. Exceptions Section 11.19. Database Access with SQL Section 11.20. Sending Pipe Messages (DBMS_PIPE) Section 11.21. Signaling Events with Alerts (DBMS_ALERT) Section 11.22. Email Notification with Triggers and Alerts ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
