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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial