Skip to Main Content

Explore Oracle PL/SQL

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

September 03

14:00 UTC   Start Times Around the World

Description

Triggers: You Say Stop, I Say Go
Triggers, more specifically DML triggers, are blocks of code that run automatically when the associated event occurs on a table. Some developers use them a lot. Many others say “Never use triggers!” What’s a DB dev to do? In our September PL/SQL Office Hours, Chris and Steven explore some of the nuances of triggers and have a BIG ARGUMENT over how and when they should be used. Well, OK, maybe not a BIG argument. But we’ll be happy to argue with anyone who shows up. Well, not ARGUE, exactly.

Guest appearances from Toon Koppelaars, of the Oracle Real World Performance Team, and Jacek Gebal of utPLSQL v3 fame.

Highlights below, with great discussion sprinkled throughout.

00:57 Making best use of AskTOM Office Hours website
01:50 Overview of controversy over triggers
03:40 Jacek Gabel and his experience with triggers
08:15 Toon Koppelaars on "Triggers Considered Harmful, Considered Harmful"
22:21 Evaluate several triggers, and moving trigger code to PL/SQL API
35:56 Using Flashback Data Archive for row change auditing
44:31 Final Q&A and closing comments

Subscribe to give us feedback and be notified of upcoming sessions!

Having trouble watching the video on this page? Open the video in your browser.

Your Experts

Chris Saxon
Chris Saxon, Oracle Developer Advocate for SQL    
Chris Saxon is the quizmaster for the Database Design competitions and an Oracle Developer Advocate for SQL. His job is to help you get the best out of the Oracle Database and have fun with SQL! He's also part of the answer team on Ask TOM and creates YouTube videos at The Magic of SQL channel.
Steven Feuerstein
Steven Feuerstein, Developer Advocate for PL/SQL    
Steven Feuerstein leads a team of Developer Advocate at Oracle Corporation, and is obsessed with the Oracle PL/SQL language, having written ten books on it (all published by O'Reilly Media). He's published over 1400 quizzes on PL/SQL at the Oracle Dev Gym.
ToonKoppelaars
ToonKoppelaars, Consulting Member of Technical Staff    
Toon has been part of the Oracle eco-system since 1987. He is currently a member of Oracle's Real-World Performance team. The RWP-team troubleshoots application performance issues in and around the DBMS. The way applications currently use the DBMS, is often at the root of these performance issues. Prior to joining the RWP team, Toon has been mainly involved in database application development. His special interests are: architecting applications for performance and scalability, database design, and business rules / constraints modeling (see his idea on SQL Assertions here https://community.oracle.com/ideas/13028). He is a long-time champion of the Smart Database paradigm, i.e. using the database as a processing engine, and not just as a persistence layer.