PARTS OF TRIGGER

Parts of Trigger:

1. Trigger Time
2. Trigger statement
3. Trigger level
4. Trigger restriction
5. Trigger body

Triggers are divide into two types:

1. DML Triggers
2. STATEMENT Triggers.

1.DML Triggers:DML Triggers are those Triggers will fire against  DML Transactions such as                                       update,delete,insert.

NOTE:Trigger Never Fire against a select Operation.

2.DATABASE Triggers:Database Triggers are those Triggers will Fire whenever the user log on to the database or whenever the user logoff from the database when these Triggers should be fired.

                         These triggers can fired by database administrator to find out how much time span the particular user connected to the database and within the span of time what kind of operations we performed we can find out through this Triggers.