How many triggers can be implemented for a table?
Answer Posted / 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 View All Answers
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Is it possible to Restore a Dropped Table using Rollback Command in Oracle SQL Plus ?
How to add, remove, modify users using sql?
How to start oracle sql developer?
What are secondary keys?
What are crud methods?
Can you inner join the same table?
What are different sql data types?
Explain the savepoint statement.
Which certification is best for sql?
What is difference between hql and sql?
what is the use of double ampersand (&&) in sql queries?
What are three advantages to using sql?
What is composite data type in pl sql?
What are all ddl commands?