Home » SQL & PL/SQL » SQL & PL/SQL » Order of Trigger Types (11g Release 11.2.0.3.0)
Order of Trigger Types [message #666462] Mon, 06 November 2017 10:30 Go to next message
whdyck
Messages: 17
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
Re: Order of Trigger Types [message #666464 is a reply to message #666462] Mon, 06 November 2017 10:39 Go to previous messageGo to next message
ThomasG
Messages: 3205
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The order seems to be:



Run all BEFORE statement triggers that apply to the statement.
Run all BEFORE row triggers that apply to the statement.
Run all AFTER row triggers that apply to the statement.
Run all AFTER statement triggers that apply to the statement.

According to:

https://docs.oracle.com/cd/B19306_01/server.102/b14220/triggers.htm#i13362

[Updated on: Mon, 06 November 2017 10:41]

Report message to a moderator

Re: Order of Trigger Types [message #666465 is a reply to message #666464] Mon, 06 November 2017 11:01 Go to previous messageGo to next message
BlackSwan
Messages: 25720
Registered: January 2009
Location: SoCal
Senior Member
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2575882200346616184
http://www.oracle.com/technetwork/testcontent/o58asktom-101055.html
http://rwijk.blogspot.com/2007/09/database-triggers-are-evil.html
https://stackoverflow.com/questions/460316/are-database-triggers-evil
https://oracle-base.com/blog/2016/08/24/database-triggers-use-at-your-own-risk/

Please Read & HEED!
Re: Order of Trigger Types [message #666468 is a reply to message #666465] Mon, 06 November 2017 18:40 Go to previous messageGo to next message
whdyck
Messages: 17
Registered: May 2017
Junior Member
BlackSwan wrote on Mon, 06 November 2017 11:01
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2575882200346616184
http://www.oracle.com/technetwork/testcontent/o58asktom-101055.html
http://rwijk.blogspot.com/2007/09/database-triggers-are-evil.html
https://stackoverflow.com/questions/460316/are-database-triggers-evil
https://oracle-base.com/blog/2016/08/24/database-triggers-use-at-your-own-risk/

Please Read & HEED!

@BlackSwan:
Yes, I've seen your rant before about the evil of triggers. Unfortunately, I don't live in the same purist paradise that you do: I have a real job in a development shop where I don't have the luxury of telling my boss I won't code triggers: they were here long before I came along, and no one's gonna listen to me if I tell them to get rid of the triggers.

Since triggers are listed as a topic for this forum, please consider just passing on questions about them if you're unable or unwilling to answer. Thanks.
Re: Order of Trigger Types [message #666474 is a reply to message #666465] Tue, 07 November 2017 08:18 Go to previous message
Bill B
Messages: 1697
Registered: December 2004
Senior Member
BlackSwan wrote on Mon, 06 November 2017 12:01
https://asktom.oracle.com/pls/apex/f?p=100:11:0::::P11_QUESTION_ID:2575882200346616184
http://www.oracle.com/technetwork/testcontent/o58asktom-101055.html
http://rwijk.blogspot.com/2007/09/database-triggers-are-evil.html
https://stackoverflow.com/questions/460316/are-database-triggers-evil
https://oracle-base.com/blog/2016/08/24/database-triggers-use-at-your-own-risk/

Please Read & HEED!
You are being unrealistic. If all coding going against the database is your own development then you can easily avoid triggers. However if you are running a canned application where you have to change certain actions by the package then the ONLY way to do it on the fly is to use triggers. I live in the real world where you have to make compromises to make things work.
Previous Topic: query datewise howmany records
Next Topic: update query
Goto Forum:
  


Current Time: Fri Nov 24 23:24:34 CST 2017

Total time taken to generate the page: 0.21779 seconds