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

Showing Answers 1 - 15 of 15 Answers


  • 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.


  • Jun 7th, 2006


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.



  • Oct 5th, 2006

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

  Was this answer useful?  Yes


  • 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


  • 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


  • 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


  • 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.


  2. CREATE OR REPLACE TRIGGER trg_test_null_8

  3. before INSERT ON test_null

  4. FOR each ROW

  5. WHEN (NEW.a = 8)


  7.   NULL;


  Was this answer useful?  Yes


  • Nov 19th, 2014

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

  Was this answer useful?  Yes


  • Feb 19th, 2015


  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


  • 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