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
300 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
Similar Questions
+1 vote
how to update table using values of multiple columns from other tables in Oracle SQL

Do i need to write in PL/SQL or is it possible in SQL query?

...