Old New Value « Trigger « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Trigger
  3. Old New Value
1.Reference old and new value by column in a before update Trigger
2.This trigger uses predicates to log changes to the myStudent table.
3.These triggers demonstrate the use of the :new correlation identifier.
4.Create a trigger with 'REFERENCING new AS'
5.:old and :new Pseudo-records
6.If updating and new value equals old value
7.if ( updating or deleting ), if ( inserting or updating )
8.Output new and old value in a before update trigger