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
3*2*2=12
insert/delete/update3
before/after2
row/statement-2
Is This Answer Correct ? | 95 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 ? | 57 Yes | 3 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 / sumedh tayade
Maximum 12 Trigger can be applied on a single table.
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / samir
You can have 1 each INSTEAD OF trigger for INSERT, UPDATE,
and DELETE.
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
under "Triggers".
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 ? | 7 Yes | 8 No |
What is oracle used for?
What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
What are the attributes of cursor?
Explain the importance of .pll extension in oracle?
What is an UTL_FILE.What are different procedures and functions associated with it?
Define the terms primary key foreign key and also the difference between primary and the unique key
how can we store any pdf file in oracle
How to define a data field as not null?
how to get second highest sal of emp table
What are the uses of Database Trigger ?
We have one Package(which has many function/procedures, SQL quires etc). Now we need to check, which query or procedure is taking lot of time in that Package. ? How do we do it.