Showing posts with label What are the values of :new and :old in Insert/Delete/Update Triggers ?. Show all posts
Showing posts with label What are the values of :new and :old in Insert/Delete/Update Triggers ?. Show all posts

What are the various types of database triggers ?

What are the various types of database triggers ?
There are 12 types of triggers, they are combination of :
Insert, Delete and Update Triggers.
Before and After Triggers.
Row and Statement Triggers.
(3*2*2=12)

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

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