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 do clean up if create database failed?

1015

When do you get a .pll extension in oracle? Explain its importance

1020

How do I know if oracle client is installed on windows?

1005

How to create tables for odbc connection testing?

1088

Why do you use stored procedures and state some of its disadvantages?

1014

why dont we assign not null constraint as table level constraint.

2720

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2082

What is null value in oracle?

1082

What are the restrictions in a oracle read only transaction?

1010

What are named parameters?

1077

What is oracle analytical function?

1115

Explain integrity constraint?

1149

What is a data dictionary and how can it be created?

1120

What is control file used for?

1182

Can group functions be mixed with non-group selection fields?

1008