Creating Models › Target Servers for Physical Models › Database Property Editors › Oracle Physical Property Editors › Oracle Triggers Editor › Define an Oracle Database Trigger

Define an Oracle Database Trigger

Use the Oracle Trigger Editor to define the stored procedures that exist for a database in an Oracle physical model.

To define an Oracle database trigger

1. Right-click the database trigger in the Model Explorer that you want to define and click Properties.

   Note: Click New if there are no database triggers in your model.

   The Oracle Trigger Editor opens.

2. Select the database trigger in the Navigation Grid that you want to define and work with the following options:

   Note: Click New on the toolbar to create a new database trigger. Use the Enter filter text box to filter a very large list of database triggers to quickly locate the one that you want to define.

   Database

   Displays the database to which the trigger belongs. You can use the drop-down control to select a different database.

   Name

   Displays the database trigger name. You can change the trigger name in this field.

   DB Owner

   Lets you assign the database owner for the database trigger. Enter the database owner in this field.

   Use Replace Syntax

   Specifies to use REPLACE syntax for the database trigger. 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.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the General tab and specify execution information for the trigger.
4. Click the When tab to review or edit a WHEN condition that applies to the trigger.
5. Click the Code tab to define the code type for the database trigger.
6. Click the Expanded tab to view expanded code for the database trigger.
7. (Optional) Click the Comment tab and enter any comments that you want to associate with the database trigger.
8. (Optional) Click the UDP tab to work with user-defined properties for the database trigger.
9. (Optional) Click the Notes tab to view history associated with the database trigger and to add or view user notes.
10. Click Close.

    The database trigger is defined and the Oracle Trigger Editor closes.