Difference between database triggers and form triggers.

Answer

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.

Oracle Triggers - Posted on August 28, 2008 at 17:00 PM by Amit Satpute