| | Copyright |
| | About Prentice Hall Professional Technical Reference |
| | Preface |
| | | Who Will Benefit from This Book? |
| | | How Is This Book Structured? |
| | | Conventions |
| | | Acknowledgments |
| | 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 |