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

Oracle Triggers Editor

You can create triggers, which are a named set of precompiled SQL statements stored on the server that are automatically executed when a specific event occurs. For example, a trigger can be executed when a row in a table is inserted, updated, or deleted. The trigger tells the DBMS how to process the SQL INSERT, UPDATE, or DELETE commands to enforce business rules.

Use the Oracle Trigger Editor to create or edit triggers for Tables, Materialized Views, Views, or Databases.

You can open the Oracle Trigger Editor in one of the following ways:

• Select Triggers from the Database menu and select either Table Triggers, Materialized View Triggers, View Triggers, or Database Triggers
• For a table trigger, right-click a table in the diagram and select Triggers from the menu
• Right-click a trigger in the Model Explorer and select Properties
• Single-click a trigger in the Model Explorer and click the Property Editor icon

Database triggers are supported in the following features:

• Forward Engineering
• Reverse Engineering