Triggers Sequence

[Trevisolli]

Environment information:
* Oracle version: 10.2.0.3.0
* Operating system: Windows Server

Personal, good afternoon.

with a cruel doubt, but, I never came across the situation and, as I was asked, I decided to pass on to the experts here:

:
I have 07 triggers on a table.

Doubt:
What are the sight of these triggers, assuming two of them (or more), are Before Insert?

Is the creation order of the trigger? How does the bank interpret this situation?

Thank you very much.

[gilbertoca]

Boy, Good Question! rs rs
So far I have not had this need, to know the sequence of triggers.
But the documentation is very good:
Running of triggers: http://download.oracle.com/docs/cd/B193 ... m#CNCPT418
Order: http://download.oracle.com/docs/cd/B193 ... sthref1179
Update:
Not to be without a complete response:

Oracle Fires Multiple Triggers in An Unspecified, Random Order, IF More Than One Trigger Of The Same Type Exists Given Statement; That is, Triggers of the Same Type for the Same Statement ARE NOT LEARANTED TO FIRE IN ANY SPECIFIC ORDER .

Gilberto

[Trevisolli]

Thanks again Gilberto.
Ball show the link.

[dr_gori]

From Oracle 11g it has to define the order of execution of the triggers: http://glufke.net/2009/05/14/execucao-o ... oracle11g/
: -O

[dr_gori]

If you are using the order in the execution of the triggers, you can consult through this query:

Select all

select 
  trigger_owner, 
  trigger_name, 
  referenced_trigger_owner, 
  referenced_trigger_name, 
  ordering_type 
from 
  dba_trigger_ordering;