dhana

• Apr 27th, 2006

 

hi

    Only 12 triggers are created in one table

if any thing wrong pls reply this

bye

GURUDAS

• Jun 9th, 2006

 

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

AmitDeshpande

• Jul 25th, 2006

 

This is about ORACLE, but what about SQL

dmadhusudhanarao

 Profile Answers by dmadhusudhanarao 

• Aug 2nd, 2006

 

i am sorry to say this thing that your answer is wrong. you can put a max of 18 triggers in one table.

Girdhar Singh

• Aug 21st, 2006

 

  total 12 trigger we created but we write trigger how much we want

Nasim

• Dec 19th, 2006

 

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