Triggers Editor (Oracle)

From RapidSQL
Jump to: navigation, search

Go Up to Oracle Object Editors

The Triggers Editor lets you modify actions, events, and other details for a trigger.

To edit a trigger

  1. Open an editor on the trigger. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

In addition to displaying basic identification and creation properties, this tab lets you work with settings in the following categories:

Attributes

Lets you specify whether the trigger is Enabled, select the Trigger Timing (BEFORE, AFTER, COMPOUND), and the Trigger Type (ROW, STATEMENT).

Correlation Names

Lets you provide an Old Table Alias and a New Table Alias as well as construct a When Clause.

Status

Lets you view Object Status, Create Date, Last Modified, and Base Object Type properties.

Size Information

Lets you view Source Size, Parsed Size, Code Size, and Error Size properties.

For detailed information on these properties, see Triggers (Oracle) - Properties.

Events

Lets you select the DDL, DML, or Database manipulation events that fire this trigger. For detailed information,see Triggers (Oracle) - Events.

Column Selection

For triggers firing on UPDATE events, lets you work with the associated columns. For detailed information,see Triggers (Oracle) - Column Selection.

Action

Lets you modify the trigger action PL/SQL block for any trigger on the datasource. You modify the body of the trigger in the Trigger Action (PL/SQL Block) area. For detailed information,see Triggers (Oracle) - Action.

Dependencies

For details on using this tab, see Working with Object Dependencies.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.