Question: Case 9 - 1 : Mapping the Flow of Database Triggers After you learn how to create triggers, you realize that one statement can end
Case : Mapping the Flow of Database TriggersAfter you learn how to create triggers, you realize that one statement can end up firing off a number of triggers. Not only can you have multiple triggers attached to a single table, but also a trigger can perform DML operations that might affect other tables and fire off other triggers. To prevent this problem, you might be able to combine triggers to make your code clearer and easier to maintain. For example, if you have one trigger for an INSERT statement on the BBPRODUCT table and another for an UPDATE statement on the BBPRODUCT table, you might want to combine them into one trigger and use conditional predicates. In addition, triggers that run DML statements that could fire off additional triggers could lead to a mutating table error. However, this error might not be apparent unless you identify the flow of trigger processing and associated objects.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
