[ Oracle PL/SQL ] System Event Triggers About: Created on either a schema or the database A SCHEMA trigger is created on a schema...

Compound Triggers About Compound triggers: First appeared in Oracle 11g. Can fire at multiple timing points. Each timing point secti...

DML Triggers DML triggers : Simple Compound can fire at one, some, or all of the preceding timing points INSTEAD OF Created o...

DDL Triggers Can be used to: Monitor significant events in the database. Monitor errant code that can that can corrupt or destabiliz...

NON-UPDATABLE Views contain any: One or more Table Joins . A GROUP BY clause. START WITH ...CONNECT BY . DISTINCT . Aggregat...

You can create triggers on object tables . In this case, the trigger can reference the pseudocolumn OBJECT_VALUE. In the example below you:...

Triggering Introduction DDL Triggers DML Triggers Compound Triggers INSTEAD-OF Triggers System or Database Event Triggers ...