14
Mutating Tables and Compound Triggers
In the preceding chapter, you explored the concept of triggers. You learned about the use of 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 discover how triggers can be used to resolve these issues.
Lab 14.1: Mutating Tables
A table against which a DML statement is issued is called a mutating table. For a trigger, the mutating table is the one on which the trigger is defined. If a trigger tries to read or modify ...
Get Oracle PL/SQL by Example, 6th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
