Prepare for your Next Interview
This is a discussion on Trigger Execution Order within the Oracle forums, part of the Databases category; I executed Database Trigger execution order example given in HOW TO's for update statement. Before update on table and After update on table are executed irrespective of whether update ...
|
|||
|
Trigger Execution Order
I executed Database Trigger execution order example given in HOW TO's for update statement.
Before update on table and After update on table are executed irrespective of whether update statement updates rows or not? What is the use of firing these two triggers eventhough not even a single row effected? When do we use these two triggers? |
| Sponsored Links |
|
|||
|
Trigger Execution Orders are different according to the Trigger u r using.
There are two types of Triggers generaly used. 1. Application Triggers 2.Database trigger. Each type of trigger (say application trigger or Database trigger)having different execution order.Pls leave message which trigger u r using.. |
![]() |
|
| Thread Tools | |
| Display Modes | |
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| what is a trigger? | srinu.tenali | SQL Server | 11 | 3 Weeks Ago 01:57 AM |
| trigger | jayanth511 | SQL | 7 | 06-28-2008 02:37 AM |
| Trigger | goodstudent | SQL | 2 | 03-14-2008 07:03 AM |
| what is trigger | amaravadi11 | SQL | 8 | 01-23-2008 04:10 PM |
| Where does the execution stops exactly | Geek_Guest | SQL | 5 | 07-02-2007 04:05 PM |