How many number of triggers can be created on a table?

Showing Answers 1 - 35 of 35 Answers

nilkanth

  • Mar 8th, 2006
 

12 triggers max

  Was this answer useful?  Yes

Deepika S Verma

  • Apr 1st, 2006
 

Till oracle 7.0 only 12 triggers could be associated with a given table, but in higher versions of Oracle there is no such limitation.

sunil

  • Jun 7th, 2006
 

Hi,

There is no limit on number of triggers on one table.

you can write as many u want for insert,update or delte by diff names.

Sunil.

Padma

  • Oct 5th, 2006
 

if table has got n columns. we can create n triggers based on each column.

  Was this answer useful?  Yes

DEEPAK MAHAPATRA

  • Sep 5th, 2007
 

Higher version of Oracle doesn't have any limitation of the number of trigger. Earlier 12 number of triggers were fired per table.

  Was this answer useful?  Yes

g_sidhu

  • Jan 31st, 2008
 

With Oracle 10g : any number of trigger can be written on a table.
With Oracle 9.0 or below� :�� max 12

  Was this answer useful?  Yes

KSPRADEEP

  • Oct 17th, 2012
 

max 12 trigger can be created on a table.
Row level triggers and Statement level triggers
Before and After
Insert and Delete and Update
2*2*3=12

AMANDEEP SINGH

  • Jul 13th, 2013
 

There are total 28 possible types:
(3 statements + 4 combination statements) * 2 timing * 2 levels=28

  Was this answer useful?  Yes

saravana kumar (PMS_SARA)

  • Oct 11th, 2013
 

You can create n number of triggers, try the below trigger on a same table by giving different names with different when conditions.

Code
  1.  

  2. CREATE OR REPLACE TRIGGER trg_test_null_8

  3. before INSERT ON test_null

  4. FOR each ROW

  5. WHEN (NEW.a = 8)

  6.  


  7.   NULL;

  8.  

  Was this answer useful?  Yes

Soumya

  • Nov 19th, 2014
 

In oracle 11g , there is no limit for number of triggers on a table.

  Was this answer useful?  Yes

chakravarthy

  • Feb 19th, 2015
 

12

  Was this answer useful?  Yes

Abhijit Musale

  • Mar 23rd, 2015
 

There is no limit to the no. of triggers that can be created on a table. Whereas there are 12 possible combinations of triggers that can be created using the combination of (insert/update/delete)*(Before/After)*(Row Level/Statement level)

  Was this answer useful?  Yes

Ratnesh gupta

  • Apr 2nd, 2015
 

There is no technical limit on the number of triggers you define (or, at least, not one that any rational person has ever hit). It generally wouldnt make sense to have more than one trigger of a given type on a particular table though you can come up with situations where you might want to have multiple triggers of the same type on a single table.

  Was this answer useful?  Yes

Ram

  • Oct 29th, 2015
 

You can create n number of triggers on a table but maximum types of triggers you can create are 12.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions