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

Explain alias?

1193

What are the differences between interval year to month and interval day to second?

1064

What is oracle rowcount?

1145

How to use regular expression in pattern match conditions in oracle?

1075

Explain an exception and its types?

1135

What is the max number of columns in an oracle table?

1047

How many types of auditing in Oracle?

1086

What is key preserved table?

1080

Is rowid unique in oracle?

1044

What is the difference between sharding and replication?

1136

How to get a list of all background sessions in the database?

1040

What is the data pump import utility?

1074

what is the use of system.effective.date variable in oracle?

1161

How to delete a column in an existing table?

1130

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2066