Constraining Attribute Values
Constraining Values with User Defined ‘Types’
More Complex Constraints...
Declaring Assertions
Another Example
Different Constraint Types
Triggers
Elements of Triggers (in SQL3)
Example: Row Level Trigger
Statement Level Trigger
Bad Things Can Happen
Embedded SQL
Programs with SQL
The Impedance Mismatch Problem
Interface: SQL / Host Language
Using Shared Variables
Single-Row Select Statements
Cursors
More on Cursors
Recursion in SQL-3
Email: alon@cs.washington.edu
Home Page: http://www.cs.washington.edu/homes/alon
Download presentation source