Lesson 1
Creating a trigger
This module covers a tool that designers sometimes overlook when creating a database system: the database trigger.
The database trigger can add functionality to the database that might otherwise need to be handled by specialized coding.
By the end of this module, you will know how to:
The next lesson defines the trigger.
The database trigger can add functionality to the database that might otherwise need to be handled by specialized coding.
By the end of this module, you will know how to:
-
Distinguish between a trigger and a procedure
-
Describe the syntax and use of special record variables
-
Create an insert, update, or delete trigger
- Build and execute a trigger that covers insert, update, and delete
The next lesson defines the trigger.