Duration: 20:34 min
Summary: Triggers are PL/SQL blocks associated with tables, views or a schema. They are one of the most important database objects because they allow the creation of complex business rules and logic that will be associated with the data stored in tables. This video explain the trigger concept and show the details of timming, event, type, when clause, firing sequence, :NEW and :OLD qualifiers, and the internal DELETING, INSERTING and UPDATING variables. The examples contained in this video explain every detail of DML (Data Manipulation Language) triggers and also how to create a simple DDL (Data Definition Trigger).