What are the types of triggers ?
Answer Posted / kumar sudeep
1. Cyclic Cascading Triggers.
2. Mutating Triggers.
3. Insted Off Triggers.
All the above with differences in areas of implementaion
difference as below:
1. Database.
2. Application.
And with ways of implementation differences as below:
1. BEFORE/AFTER.
2. Insert/Update/delete.
3. Statement level/Row level.
| Is This Answer Correct ? | 12 Yes | 7 No |
Post New Answer View All Answers
What are aggregate and scalar functions?
What is sql analyzer?
Explain some predefined exceptions.
How to write html code in pl sql?
What is the difference between explicit and implicit cursors in oracle?
Cite the differences between execution of triggers and stored procedures?
Is mariadb a nosql database?
What is the difference between a query and a report?
Can we rollback after truncate?
How is sql used in oracle?
What is mutating table error?
Define tables and fields in a database
What is record variable?
How much ram can sql express use?
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba