A script-enabled browser is required for this page to function properly.

About the Database Trigger Editor

 

Table Owner Combo Box

The Table Owner combo box identifies the user who owns the database trigger currently displayed in the editor.

Selecting a new entry in the Table Owner combo box updates the Table combo box and displays the first database trigger in the Name List (if one exists).

Table Combo Box

The Table combo box displays the tables owned by the current user.

Name Combo Box

The Name combo box displays the name of the currently selected database trigger.

The Name combo box contains the names of all accessible database triggers owned by the user currently selected in the Owner combo box. A database trigger is accessible if the current user has execute privileges on it.

Selecting a new entry in the Name combo box updates the editor to display the newly selected database trigger. If the source text of the current database trigger has been modified, the editor presents an Unsaved Changes alert.

Triggering

When defining a database trigger, you can specify the trigger timing, that is, you can specify when the trigger action is to be executed in relation to the triggering statement: before or after the triggering statement.

Statement

A triggering event or statement is the SQL statement that causes a trigger to be fired. A triggering event can be an INSERT, UPDATE, or DELETE statement for a specific table.

For Each Row

When you create a database trigger, you can specify a trigger restriction. A trigger restriction is an option available for triggers that are fired for each row. Its function is to conditionally control the execution of a trigger. A trigger restriction is specified using a WHEN clause.

Trigger Body

Allows you to specify the PL/SQL code to be used as the body of the database trigger.

New

Creates a new code object of the same type and scope as the current code object. For example, when the current object is a trigger attached to an item, choosing New displays the Triggers LOV that allows you to create a new trigger attached to the same item. When the current object is a program unit, choosing New invokes the New Program Unit dialog.

Save

Compiles and saves the code in the Source Code field. The compiler detects syntax errors, semantic errors, and references to non-existent objects, procedures, and functions. When you compile successfully, the status line displays the message <Successfully Compiled>.

Revert

Undoes any changes that were made to the source code since the editor was invoked or since the last Apply or Revert command. Revert is disabled when there are no unapplied changes.

Drop

The Drop command drops an existing database trigger or aborts the creation of a new one (after seeking confirmation via an alert).

After dropping the database trigger, the editor displays the preceding database trigger in the Name combo box if one exists; otherwise, it displays the next database trigger. If there are no database triggers for the current owner, the editor is empty.

The Drop button is enabled only if the database trigger is new or the current user has drop privileges for the currently displayed database trigger.

Close

Closes the Database Trigger Editor.

Clicking a compilation message

Moves the insertion point to the line at which an error was detected in the Source Code field.


About database triggers

Creating a database trigger