RE: how many types of data base triggers are there, ...
hi some additions to Ram pratap answer:There are actually two types of triggers: DATABASE and APPLICATION triggers.Database triggers are of three types:1)DML trigeers: we can have a total of 12 DML trigger. ( 3 triggers based on statement i.e. INSERT UPDATE DELETE * 2 triggers based on timing i.e. BEFORE and AFTER * 2 triggers based on levels i.e. ROW and STATEMENT 12)2)Instead of trigger: used for updating views based on join condition.3)System trigger: these are the triggers whcih fire on DDL or database events.answer for the remaining two question is same as to what ram has written.cheers.
