|
Triggers are constructs in PL/SQL that need to be just created and associated with a table....
|
|
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....
|
|
When we write a trigger, we also have to give the reference of the table the trigger has to be fired on.....
|
|
Triggers can be fired based on the following criteria: Category - (INSERT, DELETE, UPDATE) i.e. which kind of DML statement causes the trigger to fire...
|
|
A database trigger is fired when a DML operation is fired on some database table. On the other hand form triggers are fired when user makes some event like pressing a key or navigating between fields of a form...
|
