RelationalDBDesign
RedhatLinuxSys Seomining
prev next prev next
Course navigation
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:
  1. Distinguish between a trigger and a procedure
  2. Describe the syntax and use of special record variables
  3. Create an insert, update, or delete trigger
  4. Build and execute a trigger that covers insert, update, and delete
You will get lots of practice coding PL/SQL in this module.
The next lesson defines the trigger.
Course navigation