how many triggers we can create on a table
Answers were Sorted based on User's Feedback
Answer / karthikeyan.v
You can create a maximum of 12 triggers on a table
|Is This Answer Correct ?||93 Yes||13 No|
Answer / karthik
Hi Aurobinda and Karthikeyan,
see all says the same answer which is NOT right.u can hv
many number of triggers ina table but the COMBINATIONS U
CAN MAKE can be 12 only(karthikeyan ur partly rit)
ex: i can hv before insert on each row trigger 5 times ina
table it means this itself its a 5 trigger but the
combination can be 12 only.
|Is This Answer Correct ?||56 Yes||3 No|
Answer / damodar
12 is the correct answer.
|Is This Answer Correct ?||16 Yes||7 No|
Answer / ash
Limited by resources.
12 types as above. each type is limited by resources.
|Is This Answer Correct ?||16 Yes||11 No|
Answer / krishna shekhar
we can create 12 triggers on table.
|Is This Answer Correct ?||10 Yes||6 No|
Answer / sumedh tayade
Maximum 12 Trigger can be applied on a single table.
|Is This Answer Correct ?||4 Yes||2 No|
Answer / krishna
|Is This Answer Correct ?||8 Yes||8 No|
Answer / samir
You can have 1 each INSTEAD OF trigger for INSERT, UPDATE,
You can have as many AFTER triggers as you want up to the
limit of the total maximum number of SQL Server objects.
Within AFTER triggers, you can have only 1 FIRST and 1 LAST
trigger for INSERT, UPDATE, and DELETE.
This information is available in Books Online
|Is This Answer Correct ?||5 Yes||6 No|
Answer / mohit74
acc. to me only 12 trigger combination is there but we can
have more then 12 triggers on table
and the ppl talking abt instead of trigger----guys instead
of trigger is for view not for table so dont get confused.
|Is This Answer Correct ?||6 Yes||8 No|
Answer / irene
|Is This Answer Correct ?||9 Yes||18 No|
What is a data lock in oracle?
Which of the following is not a database object TABLESPACE TABLE INDEX NONE
What is Rollback Segment ?
Can we call a trigger inside a function and function inside a trigger? Give example.
how to hide the stored procedure inside a package
How to increment dates by 1 in oracle?
Explain the use of show option in imp command.
Why we choose emp number as primarykey?
Explain integrity constraints?
What is different bet native dynamic sql and Dbms_Sql?
What would you use to improve performance on an insert statement that places millions of rows into that table?
Please HELP me its urgent? If i want to EXPORT data from SQL server to ORACLE 11g then how can I replicate data from SQL to ORACLE?