Triggers Editor (Oracle)
Go Up to Oracle Object Editors
The Triggers Editor lets you modify actions, events, and other details for a trigger.
To edit a trigger
- Open an editor on the trigger. For details, see Opening an Object Editor.
- 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.