Abstract
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.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Rights and permissions
Copyright information
© 2003 Bulusu Lakshman
About this chapter
Cite this chapter
Lakshman, B. (2003). Database Triggers. In: Oracle9i PL/SQL: A Developer’s Guide. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4302-1154-9_6
Download citation
DOI: https://doi.org/10.1007/978-1-4302-1154-9_6
Publisher Name: Apress, Berkeley, CA
Print ISBN: 978-1-59059-049-2
Online ISBN: 978-1-4302-1154-9
eBook Packages: Springer Book Archive