To create a database trigger:
Choose ToolsDatabase Trigger Editor.
In the Database Trigger Editor, choose a user name (schema) from the Table Owner list.
Choose a table name from the Table list.
The Table list shows a list of table names owned by the
user shown in the Table Owner field. If you select a user name other
than your own in the Table Owner field, the Table list
list shows only the tables to which you have been granted access.
(For views only) To define an INSTEAD OF trigger for an object view, click the arrow next to Table to display a list and choose View. Then choose a view name from the View list list.
Click New
to create a new database trigger.
A unique trigger name (with respect to other triggers in the same schema)
is automatically assigned to the new trigger in the Name
list. You can modify the trigger name.
The Name list displays a list of trigger names associated
with the table (or view) shown in the Table (or View) field.
The Name list displays only the names of the database triggers
associated with the tables to which you have access.
After specifying the trigger options and action, click Save to compile the trigger.
Copyright © 1984, 2005, Oracle. All rights reserved.