In this chapter, you will learn about
• Mutating table issues
• Compound triggers
In the preceding chapter, you explored the concept of triggers. You learned about using triggers in the database, events that cause triggers to fire, and different types of triggers. In this chapter, you will continue exploring triggers. You will learn about mutating table issues and how triggers can be used to resolve these issues.
In Lab 14.1 you will see how to resolve mutating table issues in the Oracle database prior to version 11g. In Lab 14.2 you will learn about compound triggers, which were introduced in Oracle 11g, and how they can be used to resolve mutating table issues.