Welcome to Questionaries, where you can ask questions and receive answers from other members of the community.

Let us know at info@questionaries.org

Difference between database triggers and form triggers?

8 like 0 dislike
Hello
Difference between database triggers and form triggers?
please reply me. i am waiting for your reply.
Thanx
asked 1 year ago by DBA-boss (120,990 points)

1 Answer

1 like 0 dislike
 
Best answer
-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.
answered 1 year ago by eagles11 (179,830 points)

Related questions