NEW OLD « Trigger « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Trigger
  3. NEW OLD
28.3.NEW OLD
28.3.1.Old and new value
28.3.2.Reference new value with :NEW in a before insert or update trigger
28.3.3.Refernece an old value in :OLD after update trigger
28.3.4.:old and :new Pseudo-records, Example 1
28.3.5.:old and :new Pseudo-records, Example 2
28.3.6.Raise application error in a trigger in case of invalid new value
28.3.7.REFERENCING OLD AS old NEW AS new
28.3.8.REFERENCING OLD AS old_values NEW AS new_values
28.3.9.Output new and old value in a before update trigger