A script-enabled browser is required for this page to function properly.

Creating a database trigger

To create a database trigger:

  1. Choose Toolsright arrowDatabase Trigger Editor.

  2. In the Database Trigger Editor, choose a user name (schema) from the Table Owner list.

  3. 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.

  4. (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.

  5. 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.

  6. After specifying the trigger options and action, click Save to compile the trigger.

See also

About database triggers