how many triggers we can create on a table
Answer Posted / 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 |
Post New Answer View All Answers
Explain the use of compress option in exp command.
Can I create users through internet explorer in oracle 10g?
Is insert autocommit in oracle?
How to drop an index in oracle?
List out the difference between commit, rollback, and savepoint?
How do I spool to a csv formatted file using sqlplus?
How many types of segments in Oracle?
Can we commit inside a function in oracle?
What is java oracle used for?
Can u please explain me the Discussion on Except ,using cast like type cast. Question in the context of difference between two tables
What is the usage of merge statement?
What is a system tablespace?
How do we display rows from the table without duplicates?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
how to convert .db (extention) database file into .dmp (extention ) for oracle database ?