Register now or log in to join your professional community.
Baically there only1 type of trigger which can be fired on the table. .i.e., DML TRIGGER. There are14 types of DML TRIGGER But we can fire only12 types of triggers, because remaining2 types of triggers fire on View.1. Before insert on ROW LEVEL TRIGGER2.1. AFTER insert on ROW LEVEL TRIGGER3. Before insert on STATEMENT LEVEL TRIGGER4. After insert on STATEMENT LEVEL TRIGGER5. Before update on ROW LEVEL TRIGGER6. After update on ROW LEVEL TRIGGER7. Before update on STATEMENT LEVEL TRIGGER.8. After update on STATEMENT LEVEL TRIGGER.9. Before Delete on STATEMENT LEVEL TRIGGER.10 After Delete on STATEMENT LEVEL TRIGGER.11. Before Delete on ROW LEVEL TRIGGER.12 After Delete on ROW LEVEL TRIGGER
· A DML trigger is fired on an INSERT, UPDATE, or DELETE opeation on database table
· Maximum types of trigger can be attacehd to table :3 statement *2 timing *2 level
Types of DML triggers:
Category
Values
Comments
Statement
INSERT, DELETE or UPDATE
Defines which kind of DML statement caused the trigger to fire
Timing
BEFORE or AFTER
Defines whether the trigger fires before or after the statement is executed
Level
Row or Statement
If the trigger is a row-level trigger, it fires once for each row affected by the triggering statement. If trigger is a statement-level trigger, it fires once, either before or after the statement. A row-level trigger is identified by the FOR EACH ROW clause in the trigger definition.
1. Before Insert Statement level
2. Before Update Statement level
3. Before Delete Statement level
4. After Insert Statement level
5. After Update Statement level
6. After Delete Statement level
7. Before Insert Row level
8. Before Update Row level
9. Before Delete Row level
. After Insert Row level
. After Update Row level
. After Delete Row level
