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

Oracle Triggers Editor - Table Triggers - General Tab

Use the General tab in the Oracle Trigger Editor for table triggers to specify execution information for a trigger. The following describes the options for this tab:

Trigger On

Select any of the following options to specify the action for which the trigger should fire. When you select an option, you include the built-in trigger code for that action in the table trigger.

DELETE

Select this check box to fire the selected table trigger when a SQL DELETE command is executed.

INSERT

Select this check box to fire the selected table trigger when a SQL INSERT command is executed.

UPDATE

Select this check box to fire the selected table trigger when a SQL UPDATE command is executed.

Note: You can create separate table override triggers for DELETE, INSERT, and UPDATE actions, or you can combine different actions into a single trigger. If you want to combine actions, select each Trigger On check box (DELETE, INSERT, and UPDATE). For example, if you want to extend the customized table override trigger "special order-line insert" to calculate the product_sold_quantity on UPDATE, DELETE, and INSERT of ORDER_LINE, select the DELETE, INSERT, and UPDATE check boxes. Then, change the SQL code to handle the conditions for recalculating product_sold_quantity under DELETE and UPDATE conditions.

Fire

Select one of the following to specify when to fire the trigger:

BEFORE

AFTER

For Each Row

If you select this check box, enter a Referencing value for each option:

New

Old

State

If you select the State check box, select one of the following:

ENABLE

DISABLE

Columns

Lists all the columns in the selected table for which an update to the column can be used as a triggering event.

Update of Columns

Lists all the columns in the selected table for which an update to the column is a triggering event.

Parent

Displays the name of the selected table (if it is the parent table in a relationship) or the parent of the selected table, for each relationship in which the selected table is involved.

Verb Phrase

Displays the name of all the relationships for the selected table.

Integrity Rule

Lists the referential integrity rules that apply to the selected relationship. Rules are abbreviated and indicate the RI trigger action, such as CHILD UPDATE (CU).