Скачать или смотреть Database 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

Link to session: https://asktom.oracle.com/pls/apex/as...

AskTOM Office Hours offers free, monthly training and tips on how to make the most of Oracle Database, from Oracle product managers, developers and evangelists.

https://asktom.oracle.com/

Oracle Developers portal: https://developer.oracle.com/
Sign up for an Oracle Cloud trial: https://cloud.oracle.com/en_US/tryit