Database Trigger - Triggers in Oracle

Triggers in Oracle

In addition to triggers that fire when data is modified, Oracle 9i supports triggers that fire when schema objects (that is, tables) are modified and when user logon or logoff events occur. These trigger types are referred to as "Schema-level triggers".

Read more about this topic:  Database Trigger

Other articles related to "triggers in oracle, triggers, trigger, oracle":

Database Trigger - Triggers in Oracle - Mutating Tables
... Row-level triggers are executed as each row is modified, so the order in which trigger code is run is also not well-defined ... Oracle protects the programmer from this uncertainty by preventing row-level triggers from modifying other rows in the same table – this is the "mutating table" in the error message ... One solution is to have row-level triggers place information into a temporary table indicating what further changes need to be made, and then have a statement-level trigger fire ...

Famous quotes containing the word oracle:

    Know thyself.
    —Inscription on the Oracle of Apollo at Delphi, Greece, 6th century B.C.....