From the course: Oracle Database 12c: Advanced SQL

Unlock this course with a free trial

Join today to access over 25,500 courses taught by industry experts.

Introduction to table triggers

Introduction to table triggers - Oracle Database Tutorial

From the course: Oracle Database 12c: Advanced SQL

Start my 1-month free trial Buy for my team

Introduction to table triggers

“

- [Instructor] Oracle triggers allows us to specify procedures and business logic that will run implicitly when a specific database event occurs. Triggers are similar to stored procedures, but unlike stored procedures in the database, which we will learn about later in our course, and are executed on demand by users, triggers are implicitly fired, or executed, by Oracle, when specific triggering events occur in the database. One such example is a table trigger. You create a table trigger on a specific Oracle database table and associate the condition on which the trigger should execute. For example, you can configure the trigger to execute when an insert, update, or delete statement is issued against the database table associated with the trigger. What are common use cases for triggers in the Oracle database? Well, there are many. Since triggers can essentially execute any business logic you desire, written in both SQL…

Contents