Creating Models › Target Servers for Physical Models › Database Property Editors › Oracle Physical Property Editors › Oracle Triggers Editor › Oracle Triggers Editor - Database Triggers

Oracle Triggers Editor - Database Triggers

When you select Triggers from the Database menu and select Database Triggers, the Oracle Trigger Editor opens with specific options for Database Triggers. The following describes the options available for Database Triggers:

Databases

A drop-down list where you can select the database to which you want to apply the trigger.

Triggers

A list box that contains all the available triggers based on the selected database.

Owner

You can enter a name in this text box to assign a database Owner to the selected trigger.

New

Select New to create a new trigger. Opens the Create Trigger dialog where you can specify the name for the new trigger.

Rename

Select Rename to rename a trigger that you select from the Triggers list box. Opens the Rename Trigger <Trigger Name> dialog where you can assign a different name to the selected trigger.

Delete

Select a trigger from the Triggers list box that you want to delete, and click the Delete button.

Generate

Select this check box to generate a CREATE TRIGGER statement for the trigger in the schema generation script.

Create or Replace

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.

DB Sync

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 database triggers also includes the following tabs:

General

Specifies 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

Specifies a When condition that applies to a trigger.

Code

Specifies code (including macros) to a trigger.

Expanded

Displays the entire code assigned to a trigger. Code is read-only in this tab.

Comment

Lets you enter any comments that you want to associate with the object.

UDP

Lets you enter user-defined property values for the object.

Notes

Lets you view or edit user notes.