Abhishek

• Jun 6th, 2005

 

Insert/Update/Delete :- 3 
Before/After:- 2 
Row Level/Statement Level:-2 
 
Hence 3*2*2

J Lehew

• Aug 25th, 2005

 

Question may be confusing. The 3*2*2=12 is the number of different types of triggers.  
 
I've seen more than 25 triggers on a single table before with multiple before update triggers and multiple before insert triggers. The issue with multiple triggers is there is no guarantee of the order they get executed in so there can be timing issues in this situation. When this happens you have to combine the two triggers so execution order can be controlled.

karthik

• Nov 16th, 2005

 

you can have N number of triggers !!!!

Venugopal Chowdary.M

• Dec 16th, 2005

 

We can have maximum of 16 triggers applied on a table

mukeshmajhi

• Jan 23rd, 2006

 

there can be n number of trigger can have in a table . type of trigger may be 12

tanujarsingh78

 Profile Answers by tanujarsingh78 

• Mar 8th, 2009

 

Till Oracle 7.0, only 12 triggers could be defined per table. In later versions there is no such limitation.

abhi_only12000

 Profile Answers by abhi_only12000 Questions by abhi_only12000

• Jan 1st, 2010

 

You can hav many number of triggers in a table but the COMBINATIONS YOU CAN MAKE can be 12 only.

For ex: I can have before insert on each row trigger 5 times in a table it means this itself it is a total of 5 trigger but the combination can be 12 only.

viswa

• Feb 2nd, 2012

 

I feel there is no necessary in creating more than one before insert statement. so with total of 12 combinations you can create what ever you want to do.

Navneet Jha

• Jan 9th, 2013

 

You can create N numbers of triggers on a table but the maximum possible types trigger can be applied is 3*2*2=12

(Insert/Update/Delete= 3, Before/After= 2, Row Level/Statement Level=2)

shirish

• Apr 2nd, 2013

 

Depends on maximum number objects in the database.

Polash

• Mar 11th, 2015

 

There is no limit to the number of triggers that a table can have, but type of triggers which a table can have is 12/

gopalakrishna

• Jul 28th, 2015

 

12 different triggers

Sathiya

• Feb 19th, 2017

 

You can create N numbers of triggers on a table but the maximum possible types trigger can be applied is 3*2*2=12
(Insert/Update/Delete= 3, Before/After= 2, Row Level/Statement Level=2)

Geek

• Feb 19th, 2018

 

NO there are Maximum 12 triggers