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)
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 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
INSERT : new = new value, old = NULL
DELETE : new = NULL, old = old value
UPDATE : new = new value, old = old value
Subscribe to:
Posts (Atom)