How many triggers can be implemented for a table?

Question Posted / dev

3 Answers
6341 Views
HSBC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How many triggers can be implemented for a table?..

Answer / msy

12 Trigger can be created on a single table.

Is This Answer Correct ?

5 Yes

1 No

How many triggers can be implemented for a table?..

Answer / nishi

Before oracle 10g 12 trigger possible after oracle 10g more than 12 trigger we can use

Is This Answer Correct ?

1 Yes

0 No

How many triggers can be implemented for a table?..

Answer / hairreddy

we can create more no of triggers on a single table but we can apply 12 different type of triggers only on a table
before -- for this table level and row level (insert/update/delete)-----total 6
after-- for this table level and row level (insert/update/delete)-----total 6

total 12 different triggers we can write on a table

Is This Answer Correct ?

0 Yes

0 No

Post New Answer