How many triggers can be implemented for a table?
Answers were Sorted based on User's Feedback
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 |
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 |
What is cross join sql?
how to delete duplicate rows from a specified table(only single table) how do you know which join is need to be used
Store procedure will return a value?
How do you copy a table in sql?
How can you create Cursor with parametres ?
What is difference between sql and mysql?
Is id a reserved word in sql?
What is the difference between pl and sql?
what is cursor procedure
What is the diffrence between IN and EXISTS.which one is faster.
Why do we need unique key in a table?
What are reports usually used for?