Difference between database triggers and form triggers?
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.
RE: Difference between database triggers and form trig...
form triggers is fired when an event occurs for eg when mouse is clicked when list item changed whereas database triggers fires for each DML operations performed on the associated table and it can be at row level or statement level.
RE: Difference between database triggers and form trig...
yes Sampath is right but i want to add one more thing in that in database trigger you have an option whether you can fire it before and after the event but in form trigger we cant.
