Tell Me
 

Creating Triggers
Previous previous|next Next Page



Types of Triggers
Triggers can be either of the following:

  • Application trigger: This trigger fires whenever an event occurs with a particular application
  • Database trigger: This trigger fires whenver a data event (such as DML) or system event (such as logon or shutdown) occurs on a schema or database.

Guidelines for Designing Triggers

  • You can design triggers to perform related actions and centralize global operations.
  • You should not design triggers where functionality is already built in to the Oracle server.
  • Avoid designing triggers that duplicate other triggers.
  • You can create stored procedures and invoke them in a trigger if the PL/SQL code is very lengthy.
  • Excessive use of triggers can result in complex interdependencies that may be difficult to maintain in large applications.