Explain Difference Between Database Triggers And Form Triggers
Posted by Scott
14 Feb, 2012
-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.
-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.
Comments Received:
Please give your suggestions and feedback: