GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  SQL Plus
Go To First  |  Previous Question  |  Next Question 
 SQL Plus  |  Question 49 of 132    Print  
What is the maximum number of triggers, can apply to a single table

  
Total Answers and Comments: 6 Last Update: March 08, 2009   
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
June 06, 2005 06:05:16   #1  
Abhishek        

RE: What is the maximum number of triggers, can apply to a single table
Insert/Update/Delete :- 3
Before/After:- 2
Row Level/Statement Level:-2

Hence 3*2*2

 
Is this answer useful? Yes | No
August 25, 2005 12:58:15   #2  
J Lehew        

RE: What is the maximum number of triggers, can apply to a single table
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.

 
Is this answer useful? Yes | No
November 16, 2005 09:16:28   #3  
karthik        

RE: What is the maximum number of triggers, can apply ...

you can have N number of triggers !!!!


 
Is this answer useful? Yes | No
December 16, 2005 08:41:56   #4  
Venugopal Chowdary.M        

RE: What is the maximum number of triggers, can apply ...
We can have maximum of 16 triggers applied on a table
 
Is this answer useful? Yes | No
January 23, 2006 05:26:33   #5  
mukeshmajhi        

RE: What is the maximum number of triggers, can apply ...
there can be n number of trigger can have in a table . type of trigger may be 12
 
Is this answer useful? Yes | No
March 08, 2009 16:15:30   #6  
tanujarsingh78 Member Since: March 2009   Contribution: 1    

RE: What is the maximum number of triggers, can apply to a single table
Till Oracle 7.0 only 12 triggers could be defined per table. In later versions there is no such limitation.
 
Is this answer useful? Yes | No


 
Go To Top


 Sponsored Links

 
About Us -  Privacy Policy -  Terms and Conditions -  Contact -  Ask Question -  Propose Category -  Site Updates 

Copyright © 2005 - 2009 GeekInterview.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape