Triggers check for an event. When the event occurs they run the PL/SQL code associated with the trigger.
Report triggers are activated in response to report events such as the report opening and closing rather that the data that is contained in the report. They are activated in a predefined order for all reports.
Format triggers are executed before an object is formatted. A format trigger can be used to dynamically change the formatting attributes of the object.
Validation triggers are PL/SQL functions that are executed when parameter values are specified on the command line and when you accept the Runtime Parameter Form.
Database triggers are procedures
that are stored in the database and implicitly executed when a triggering
statement such as INSERT
, UPDATE
, or DELETE
is issued against the associated table.
Copyright © 1984, 2005, Oracle. All rights reserved.