can you tell me the sequence of execution of trigger

[vivekmcm]

Hi
I have one table say test
there are 4 trigger
Before statement trigger
Before rowlevel trigger
After statement trigger
After rowlevel trigger

can you tell me the sequence of execution


iam getting following answer I though this is not right tell me right answer
Before rowlevel trigger
Before statement trigger
After rowlevel trigger
After statement trigger

[SalemH]

Hi,

You cannot specify an execution order of triggers of the same type prior to oracle11G.

But, if you are using oracle11g, you can use the new feature which consists of the FOLLOWS-clause.

For more information, I had published a PL/SQL article  (in French) about the sequence of execution on this type of triggers.
Here is the link : http://salem-houali.developpez.com/tutoriels/oracle/declencheurs-lmd-dans-oracledatabase11g/

 

[SalemH]

Hi,
If you want only the right order of the execution :

Before statement trigger
Before rowlevel trigger
After rowlevel trigger
After statement trigger