Database Triggers

  • Bulusu Lakshman


In Chapter 5, I described three types of stored subprograms: procedures, functions, and packages. In addition to these subprogram types, PL/SQL enables a fourth type of stored subprogram called a database trigger. A database trigger is a stored subprogram that’s stored in the database and executed implicitly on the occurrence of an event. The event can be a DDL operation, such as an object creation, alteration, or dropping; a DML operation, such an INSERT, an UPDATE, or a DELETE on a table or view; a system event, such as database startup and shutdown, logon, and logoff; or a user event, such as schema logon and logoff.


Schema Level User Event Database Object Database Table Insert Operation 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Bulusu Lakshman 2003

Authors and Affiliations

  • Bulusu Lakshman

There are no affiliations available

Personalised recommendations