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. |