Oracle TRIGGERS.

Preamble

A trigger is a named PL/SQL module that is stored in a database and can be invoked again. You can enable and disable a trigger, but you cannot explicitly call it.

When the Trigger is enabled, the database shall automatically call the Trigger whenever the event that triggers the Trigger occurs. While the Trigger is disabled, it shall not trigger.

You shall create the Trigger with the CREATE TRIGGER operator. You specify the triggering event in terms of the triggering operators and the object they act on. The Trigger is considered to be created or defined for an object that is either a table, representation, scheme or database.

You also specify the synchronisation point that determines whether the Trigger starts before or after execution of the Trigger Operator and whether it starts for each line affected by the Trigger Operator. By default, the Trigger is created in the enabled state.

Below is a list of articles explaining how to use triggers in Oracle/PLSQL

PL/SQL tutorial: Introduction of PL/SQL Triggers in Oracle Database

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.