What Is The Difference Between Database Triggers And Form Triggers?

1.	What Is The Difference Between Database Triggers And Form Triggers?
Answer» Data base trigger(DBT) fires when a DML OPERATION is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screen. Can be row LEVEL or statement level No distinction between row level and statement level. Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as WELL as variables in forms. Can be fired from any session executing the triggering DML statements. Can be fired only from the form that define the trigger. Can CAUSE other database triggers to fire. Can cause other database triggers to fire, but not other form triggers.

Answer»

Data base trigger(DBT) fires when a DML OPERATION is performed on a data base table. Form trigger(FT) Fires when user presses a key or navigates between fields on the screen.
Can be row LEVEL or statement level No distinction between row level and statement level.
Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as WELL as variables in forms.
Can be fired from any session executing the triggering DML statements. Can be fired only from the form that define the trigger.
Can CAUSE other database triggers to fire. Can cause other database triggers to fire, but not other form triggers.

Discussion