


Is it possible to initiate the execution of a trigger implicitly?
While DB procedures have to be called explicitly, thus representing a layer above the normal SQL level, triggers are activated implicitly by means of the SQL statements INSERT, UPDATE, and DELETE. Triggers are special DB procedures which provide a kind of "user exit" for these statements. In addition to the normal effects of these SQL statements, triggers can be used to enable further actions. Triggers are typically used to formulate integrity rules for these modifying statements in a procedural way or to execute derived actions, e.g., for the logging of applications.


