|
|
|
When you select Triggers from the Database menu and select Table Triggers, the Oracle Trigger Editor opens with specific options for Table Triggers. The following describes the options available for Table Triggers:
A drop-down list where you can select the table to which you want to apply the trigger. This list does not include external tables.
A list box that contains all the available triggers based on the selected table.
You can enter a name in this text box to assign a database Owner to the selected trigger.
Opens the Create Trigger dialog where you can specify the name for the new trigger.
Opens the Rename Trigger <Trigger Name> dialog where you can assign a different name to the selected trigger.
Select a trigger from the Triggers list box that you want to delete, and click the Delete button.
Generates a CREATE TRIGGER statement for the trigger in the schema generation script.
Select this check box if you want the trigger DDL that is generated during Forward Engineering to replace any occurrence of an identically-named trigger. If this check box is not selected, the trigger DDL generated will only attempt to create the object and will not attempt to replace it.
Starts the Complete Compare task so you can synchronize the physical objects defined in your model with the information stored on the server.
The Oracle Trigger Editor for table triggers also includes the following tabs:
General Specify general information for a trigger, such as the action for which the trigger should fire, when it should fire, how it should fire, and so on.
When Review or edit a When condition that applies to a trigger.
Code Review or assign code (including macros) to a trigger.
Expanded Review the code assigned to a trigger. Code is read-only in this tab.
Comment Add or edit comments for a trigger.
UDP Enter user-defined property values for a trigger.
| Copyright © 2012 CA. All rights reserved. | Tell Technical Publications how we can improve this information |