---

Programming Oracle Triggers and Stored Procedures (3rd Edition) (Prentice Hall PTR Oracle Series)

ISBN: 0130850330
EAN: 2147483647

Year: 2003
Pages: 111

Authors: Kevin Owens

BUY ON AMAZON

• Main Page
• Table of content
• 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
• 1.1 Before Relational Tables
• 1.2 SQL
• 1.3 Tables
• 1.4 SQL Statements
• 1.5 Table Column Datatypes
• 1.6 Behind Tables
• Chapter Two. Interacting with Oracle
• 2.1 Simplify SQLPlus for Yourself on Windows
• 2.2 Connecting
• 2.3 Connecting to an Infrastructure
• 2.4 Disconnecting
• 2.5 Command Line
• 2.6 Changes on the Command Line
• 2.7 Scripts
• 2.8 Script Output
• 2.9 Command Line Arguments
• 2.10 SQLPlus with Korn Shell
• 2.11 Batch Command Files
• 2.12 SQLPlus with Active State Perl
• 2.13 Privileges
• 2.14 DUAL
• 2.15 Autotrace
• Chapter Three. Declarative Constraints
• 3.1 Primary Key
• 3.2 UNIQUE
• 3.3 Foreign Key
• 3.4 Check
• 3.5 NOT NULL Constraints
• 3.6 Default Values
• 3.7 Modifying Constraints
• 3.8 Exception Handling
• 3.9 Data Loads
• Chapter Four. A Data Model with Constraints
• 4.1 Entity Relationship Diagram
• 4.2 Table Descriptions
• 4.3 DDL
• 4.4 Sample Data
• Chapter Five. Viewing Constraints in the Data Dictionary
• 5.1 What You Can See
• 5.2 Dictionary Views: An Overview
• 5.3 Constraint Views
• 5.4 USER_CONS_COLUMNS
• 5.5 USER_CONSTRAINTS
• 5.6 Data Dictionary Constraint Scripts
• Chapter Six. Row Trigger Mechanics
• 6.1 Introduction
• 6.2 Before versus After
• 6.3 Insert Row Trigger Syntax
• 6.4 Trigger Body
• 6.5 Example Row Triggers
• 6.6 A Table with Oracle Constraints and Business Rules
• Chapter Seven. Statement Level Triggers
• 7.1 Sequence of Events
• 7.2 Insert Statement Trigger Syntax
• 7.3 Statement Level Aggregation
• 7.4 Processing Row Captured Data
• Chapter Eight. Complex Rule Enforcement
• Chapter Nine. The PLSQL Environment
• 9.1 A Hello World Program
• 9.2 Referencing Oracle Packages
• 9.3 USER_OBJECTS
• 9.4 Dependencies among Procedures
• 9.5 USER_DEPENDENCIES
• 9.6 USER_SOURCE
• 9.7 Sharing Code
• 9.8 Compilation Dependency
• 9.9 USER_ERRORS
• Chapter Ten. PLSQL Program Units
• 10.1 Procedures
• 10.2 Functions
• 10.3 Subprogram Encapsulation: Introduction to Packages
• 10.4 Package Specification
• 10.5 Package Body
• 10.6 Application Partitioning
• 10.7 Data Abstraction
• 10.8 Parameters and Modes
• 10.9 Overloading
• Chapter Eleven. PLSQL Language Features
• 11.1 Comments
• 11.2 Assignments and Statements
• 11.3 Boolean Expression
• 11.4 Expressions with NULL
• 11.5 Logical Operators
• 11.6 String Concatenation
• 11.7 Arithmetic Expressions
• 11.8 Variable Declarations
• 11.9 Types
• 11.10 IF Statement
• 11.11 CASE Statement
• 11.12 LOOP
• 11.13 STRING Manipulation Functions
• 11.14 Miscellaneous String Functions
• 11.15 Numeric Functions
• 11.16 Random Number Generation
• 11.17 Date Functions
• 11.18 Exceptions
• 11.19 Database Access with SQL
• 11.20 Sending Pipe Messages (DBMS_PIPE)
• 11.21 Signaling Events with Alerts (DBMS_ALERT)
• 11.22 Email Notification with Triggers and Alerts