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.
  • Interview Candidate
  • 6
  • 9007

Showing Answers 1 - 6 of 6 Answers

Sampath

  • Oct 22nd, 2005
 

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.

  Was this answer useful?  Yes

jain_mk2

  • Feb 1st, 2006
 

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.

  Was this answer useful?  Yes

Mohit Dhamija

  • Jul 3rd, 2006
 

Even 'Form Trigger' can be fired before and after the event. ex- Triggers like Pre Block / Pre Record / Post Block / Post Record ..

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions