CREATE Trigger by Using OLD and NEW Qualifiers
Basically OLD and NEW qualifiers are used for row-level trigger. When a row-level trigger is createsand fires, the PL/SQL run time engine creates and populates two data structures that are …