Trigger in oracle

Triggers are constructs in PL/SQL that need to be just created and associated with a table. Once they are created, when the table associated with it gets updated due to an UPDATE, INSERT or a DELETE, the triggers get implicitly fired depending upon the instructions passed to them

The types of triggers are:       

• Row level triggers
• Statement level triggers
• BEFORE and AFTER triggers

The different types of triggers are:

• Row triggers and statement triggers: specifies how many times the trigger should get executed – Once for every row or once for every triggering statement.
• Before and after triggers – Before trigger is fired before and update, insert or triggering statement is executed. After trigger is fired after the triggering statement is executed.
• Instead of Trigger- Here, the trigger is fired instead of executing the triggering statement
• Key triggers – fired on some key action.
• Mouse trigger- fired on some mouse navigation
• Navigational trigger – fired as a result of some navigation.

The sequence of firing in a text item are as follows::

a) pre - text
b) when new item
c) key-next
d) when validate
e) post text.