GeekInterview.com
  I am new, Sign me up!
 
GeekInterview.com  >  Interview Questions  >  Oracle  >  SQL
Go To First  |  Previous Question  |  Next Question 
 SQL  |  Question 83 of 171    Print  
How many max No. of triggers I can create in a table?

  
Total Answers and Comments: 6 Last Update: December 19, 2006     Asked by: Harsabardhan Sahu 
  
 Sponsored Links

 
 Best Rated Answer

No best answer available. Please pick the good answer available or submit your answer.
April 27, 2006 03:06:42   #1  
dhana        

RE: How many max No. of triggers I can create in a tab...

hi

Only 12 triggers are created in one table

if any thing wrong pls reply this

bye


 
Is this answer useful? Yes | No
June 09, 2006 10:38:32   #2  
GURUDAS        

RE: How many max No. of triggers I can create in a tab...

Hi

Your ans is correct if you are usuing Oracle 7.1 or previous version but after 7.1 you can put as many as triggers on table.

Thanks

Gurudas


 
Is this answer useful? Yes | No
July 25, 2006 06:28:43   #3  
AmitDeshpande        

RE: How many max No. of triggers I can create in a tab...
This is about ORACLE but what about SQL
 
Is this answer useful? Yes | No
August 02, 2006 10:53:26   #4  
dmadhusudhanarao Member Since: August 2006   Contribution: 7    

RE: How many max No. of triggers I can create in a tab...

i am sorry to say this thing that your answer is wrong. you can put a max of 18 triggers in one table.


 
Is this answer useful? Yes | No
August 21, 2006 21:21:58   #5  
Girdhar Singh        

RE: How many max No. of triggers I can create in a tab...

total 12 trigger we created but we write trigger how much we want


 
Is this answer useful? Yes | No
December 19, 2006 01:32:15   #6  
Nasim        

Total 28 triggers on table

Maximum we can write 28 triggres on table

3 -> insert update and delete

4 -> combination of insert update and delete

2 -> trigger type (for each row and statement)

2 -> trigger event (before and after)

(3+4)*2*2 28


 
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