March 2008
Intermediate to advanced
458 pages
11h 25m
English
Database triggers are specialized stored programs that are triggered by events in the database. They run between the time when you issue a command and the time when the command is actually performed. As a result of being between these times, you cannot use SQL Data Control Language in triggers: SAVEPOINT, ROLLBACK, or COMMIT. You can define four types of triggers in the Oracle Database 10g family of products:
Data Definition Language (DDL) triggers These triggers fire when you create, alter, rename, or drop objects in a database schema. They are useful to monitor poor programming practices, like when programs create and drop ...
Read now
Unlock full access