How many triggers can be implemented for a table?

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

More SQL PLSQL Interview Questions

What is cross join sql?

0 Answers  


how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used

11 Answers   UST,


Store procedure will return a value?

4 Answers   eMids,


How do you copy a table in sql?

0 Answers  


How can you create Cursor with parametres ?

3 Answers  






What is difference between sql and mysql?

0 Answers  


Is id a reserved word in sql?

0 Answers  


What is the difference between pl and sql?

0 Answers  


what is cursor procedure

1 Answers   iGate,


What is the diffrence between IN and EXISTS.which one is faster.

3 Answers   Infogain,


Why do we need unique key in a table?

0 Answers  


What are reports usually used for?

0 Answers  


Categories