hi
Only 12 triggers are created in one table
if any thing wrong pls reply this
bye
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
i am sorry to say this thing that your answer is wrong. you can put a max of 18 triggers in one table.
total 12 trigger we created but we write trigger how much we want
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