Murach's Oracle SQL and PL/SQL
How to create triggers
After learning how to work with stored procedures and user-defined
functions in chapter 15, this chapter shows you how to code
another type of executable database object: a trigger. Triggers
allow you to perform tasks that would be difficult or impossible
to do with other Oracle features.
|
|
|
|
How to create a BEFORE trigger
for a table |
504 |
|
How to use a trigger to enforce
data consistency |
506 |
|
How to use a trigger to work with
a sequence |
508 |
|
How to create an AFTER trigger
for a table |
510 |
|
How to use an INSTEAD OF trigger
for a view |
512 |
|
How to use a trigger to work with
DDL statements |
514 |
|
How to use a trigger to work with
database events |
514 |
|
How to enable, disable, rename,
or drop a trigger |
516 |
|
|
How to code a compound trigger |
518 |
|
A trigger that causes the mutating-table
error |
520 |
|
How to solve the mutating-table
problem |
522 |
|
|
How to view, rename, or drop a
trigger |
524 |
|
How to enable or disable a trigger |
524 |
|
How to edit a trigger |
526 |
|
How to debug a trigger |
526 |
|
 |
|
|
|
|
© Copyright 1998-2009 Mike
Murach & Associates, Inc. All rights reserved.
|
