|
|
In this chapter, you looked at how triggers work and how you implement them. There are variations between the different RDBMS platforms in how they're created and which types of trigger are supported, but the end result is the same:
You have the ability to add code that executes when an appropriate table event occurs. You used a simple logging example to demonstrate how the various types of trigger work. Specifically, you learned about the following:
What triggers are and how they work
How to create triggers that react to inserting, updating, and deleting data
How to temporarily disable and enable SQL Server and Oracle triggers
How to use triggers and sequences in Oracle to implement autonumbering functionality
In the next chapter, you'll look at creating a product catalog case study and extracting and updating information using a variety of statements.
|
|