This is a discussion on Difference between database triggers and form triggers within the Database Support forums, part of the Web Development category; Difference between database triggers and form triggers a) Data base trigger(DBT) fires when a DML operation is performed on ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
| |||
| Difference between database triggers and form triggers a) 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 b) Can be row level or statement level No distinction between row level and statement level. c) Can manipulate data stored in Oracle tables via SQL Can manipulate data in Oracle tables as well as variables in forms. d) Can be fired from any session executing the triggering DML statements. Can be fired only from the form that define the trigger. e) Can cause other database triggers to fire.Can cause other database triggers to fire,but not other form triggers.
__________________ J.Vijayanand |
| Sponsored Links |
![]() |
| Thread Tools | |
| Display Modes | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Difference between database triggers and form triggers? | ragavraj | Database Support | 2 | 11-23-2007 04:54 AM |
| Difference between Regular database connection and Persistent Database Connections? | Falcon | PHP Programming | 1 | 11-03-2007 05:13 AM |
| Error Handling in Triggers | Murali | Database Support | 1 | 09-20-2007 07:09 AM |
| If we have multiple AFTER Triggers on table how can we define the sequence of the tri | sundarraja | Database Support | 1 | 07-24-2007 05:28 AM |
| diffrence between and constraints and triggers | sivakumar | Database Support | 1 | 07-12-2007 04:00 AM |