|
Difference between database triggers and form triggers.Database triggers (DBA)
- Fired when a DML operation is performed
- They manipulate data stored in Oracle tables
- They can cause other database triggers to fire.
- They can be fired from any session executing the triggering DML statements.
Form trigger (FT)
- Fired in response to any event that takes place while working with the forms.
- They manipulate data in Oracle tables as well as variables in forms.
- They cannot cause other form triggers to fire, but can fire other database triggers.
- They can be fired only from the form that define the trigger.Difference between database triggers and form triggers?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. A database trigger can be fired from any session executing the triggering DML statements. While form trigger is specific to the form. Database triggers can cause other database triggers to fire. On the other hand, form triggers cannot cause other form triggers to fire.
|
