Use the Table Options tab in the Oracle Trigger Editor for materialized view triggers to specify execution information for a trigger. The following describes the options for this tab:
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 materialized view trigger.
Select this check box to fire the selected materialized view trigger when a SQL DELETE command is executed.
Select this check box to fire the selected materialized view trigger when a SQL INSERT command is executed.
Select this check box to fire the selected materialized view trigger when a SQL UPDATE command is executed.
Select one of the following to specify when to fire the trigger:
If you select this check box, enter a Referencing value for each option:
If you select the State check box, select one of the following:
Lists all the columns in the selected materialized view for which an update to the column can be used as a triggering event. To fire the selected materialized view trigger template when a SQL UPDATE command is executed on a column, select the column in this list and click the button to move it to the Update of Columns list.
Lists all the columns in the selected materialized view for which an update to the column is a triggering event.
Copyright © 2013 CA.
All rights reserved.
|
|