Use the Oracle Trigger Editor to define the stored procedures that exist for a view in an Oracle physical model.
To define an Oracle view trigger
The Oracle Trigger Editor opens.
Note: Click New on the toolbar to create a new view trigger. Use the Enter filter text box to filter a very large list of view triggers to quickly locate the one that you want to define.
Displays the view to which the trigger belongs. You can use the drop-down control to select a different view.
Displays the view trigger name. You can change the trigger name in this field.
Lets you assign the database owner for the view trigger. Enter the database owner in this field.
Specifies to use REPLACE syntax for the view 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.
Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.
The view trigger is defined and the Oracle Trigger Editor closes.
Copyright © 2013 CA.
All rights reserved.
|
|