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 the left table in sql?

0 Answers  


Does sql between include endpoints?

0 Answers  


How do you truncate?

0 Answers  


What mean sql?

0 Answers  


I have done oracle 10g. I need a project knowledge. So if u please send a project how it should be done,Or you can send email link. I will be very grateful to u.

1 Answers  






What is a database? Explain

0 Answers  


what is the bond code in materialized view?

0 Answers  


What does count (*) mean in sql?

0 Answers  


What is the clause we need to add in function body to return variable?

0 Answers  


How to disable a trigger name update_salary?

0 Answers  


is it possible to pass an object or table to a procedure as an argument?

0 Answers  


how to use regular expression in pattern match conditions? : Sql dba

0 Answers  


Categories