Order of Trigger Types [message #666462] |
Mon, 06 November 2017 10:30 |
|
whdyck
Messages: 25 Registered: May 2017
|
Junior Member |
|
|
In Oracle's documentation, I see this:
Quote:The database executes all triggers of the same type before executing triggers of a different type. If you have multiple triggers of the same type on the same table, and the order in which they execute is important, use the FOLLOWS clause. Without the FOLLOWS clause, the database chooses an arbitrary, unpredictable order.
Fair enough. But is there a specified order of trigger types? I.e., Do all simple triggers fire before compound triggers? Or do the trigger types fire in a random order also?
Thanks.
Wayne
|
|
|
|
|
|
|