From the course: Oracle Database 12c: Advanced SQL

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

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

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 and PL-SQL, you can configure your triggers to perform a variety…

Contents