O'Reilly logo

Oracle by Elena Silvestrova Rakhimov, Benjamin Rosenzweig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 14 Compound Triggers

Chapter Objectives

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.

Lab 14.1 Mutating Table Issues ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required