Database Triggers

Database triggers are specialized stored programs that are triggered by events in the database. They run between the time you issue a command and the time you perform the database management system action. For this reason, you cannot use SQL Data Control Language in these 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, such as when programs create and drop temporary tables rather than use Oracle collections effectively in memory. Temporary tables can fragment disk ...

Get Oracle Database 10g Express Edition PHP Web Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.