DEVFYI - Developer Resource - FYI

What are the values of :new and :old in Insert/Delete/Update Triggers ?

ORACLE Interview Questions and Answers (Part 5)


(Continued from previous question...)

19.What are the values of :new and :old in Insert/Delete/Update Triggers ?

INSERT : new = new value, old = NULL
DELETE : new = NULL, old = old value
UPDATE : new = new value, old = old value

(Continued on next question...)

Other Interview Questions