Interested to Buy Any Domain ? << Click Here >> for more details...
how many triggers we can create on a table
- 11 Answers
- 51777 Views
- G2 Technology, TCS, I also Faced
- E-Mail Answers
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 the difference between hot backup and cold backup in oracle?
What is tns service name?
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
How to pass a parameter to a cursor in oracle?
create one table to capture an employee details with a primary key.
18. Display the clientno and total value for all orders placed by that client. Output the result in the following format: Client <clientno> has placed orders to the value of <total value>
What happens in oracle commit?
Explain the use of parfile option in exp command.
How to create a temporary table in oracle?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
What are the types of Database Links ?
How to create a new table in your schema?
Oracle General 
