You can create a maximum of 12 triggers on a table 3*2*2=12 insert/delet

how many triggers we can create on a table

Question Posted / karthikeyan.v

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

How to use "out" parameter properly?

1022

What is the usage of merge statement?

1095

What is parameterized cursor in oracle?

1064

What privilege is needed for a user to create tables in oracle?

901

What are the most common interview questions on ETL Testing for experience?

1075

How to call a stored function with parameters?

968

How to export your connection information to a file?

1073

What operating systems are supported by oracle database 10g xe?

983

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1876

What is a tns service name?

941

Where do we use decode and case statements?

942

What are the restrictions in a oracle read only transaction?

967

Can we create trigger on materialized view in oracle?

938

Does oracle database need java?

940

What is a sub query? What are its various types?

1077