Triggers in Oracle
In this course, we will explore, in-depth, the DML and System triggers available with Oracle. We will discuss the use cases and guidance for trigger usage.
What you'll learn
In this course, we will talk extensively about Oracle Triggers. Triggers help us centralize table validations at the lowest level along with providing support for auditing and logging.
We will take an in-depth look at how to define:
- Triggers
- Trigger types
- Row level triggers
- Statement level triggers
- Mutating triggers
Table of contents
- Module Overview 2m
- Row and Statement Triggers and Timing Points 4m
- Creating Triggers 5m
- Demo: Creating Triggers and Order of Execution 4m
- Trigger Conditions and Conditional Predicates 6m
- Demo: Trigger Conditions and Conditional Predicates 7m
- Enabling/Disabling Triggers and Trigger Dependencies 5m
- Demo:Enabling/Disabling Triggers and Trigger Dependencies 2m
- Summary 2m
- Module Overview 1m
- Value-based Auditing 2m
- Demo: Value-based Auditing 4m
- Logging & Autonomous Triggers 1m
- Demo: Logging & Autonomous Triggers 3m
- Automating Maintenance Tasks 1m
- Enforcing Referential Integrity 1m
- Demo: Enforcing Referential Integrity 4m
- Publishing Information 1m
- DML Against Views 0m
- Enforcing Complex Security Checks 1m
- Enforcing Complex Check Constraints 0m
- Demo: Enforcing Complex Check Constraints 2m
- Guidelines for Trigger Usage 3m
- Summary 2m
Course FAQ
Oracle triggers let you create procedures that are automatically executed when a specific action or event occurs. So if an INSERT, UPDATE, or DELETE statement is issued against a specific table, it will trigger a certain other procedure to be executed.
There are 5 different types of Oracle triggers:
- Statement triggers: DML statements on a specific table/view
- Row triggers: executes for each row affected by a DML statement
- INSTEAD OF triggers: executes on views run rather than the issuing statement
- User event triggers: DDL statements like CREATE and ALTER, user LOGON, etc.
- System event triggers: database startup, shutdown, server erros, etc.
You will learn:
- What Oracle triggers are and why use them
- Row and Statement triggers
- How to create triggers
- Trigger dependencies
- Trigger order and compound triggers
- Trigger exceptions
- Trigger scope
- Trigger applications
- Much more
The only prerequisite for this course is to have some basic Oracle PL/SQL knowledge. Check out this course if you want a refresher, or if you still need to learn Oracle PL/SQL Fundamentals.
This course is for anyone who wants to learn how to set up triggers in Oracle; both DML triggers and system triggers. If you are an Oracle programmer, you will definitely find this course beneficial.
About the author
Pankaj Jain is an experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development. He has worked on an array of technologies, with focus on Oracle at the database layer and Java at the web tier. He is a certified Oracle 11g DBA. He lives in Seattle with his wife Simita and boys Ronit and Rohak. When he is not playing with technology, he likes spending time with his kids, travelling and doing photography.