top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
69 views
What are the values of :new and :old in Insert/Delete/Update Triggers in Oracle ?
posted Dec 11, 2014 by Vidhya Sagar

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

+1 vote
 
Best answer

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

answer Dec 12, 2014 by Arun Gowda
...