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

Creating a Trigger Using Smart Triggers

To create a trigger using Smart Triggers:

  1. In the Object Navigator click on the object for which you want to attach a trigger.
  2. Choose Program | Smart Triggers...
  3. Choose a trigger from those displayed in the submenu.
    The PL/SQL Editor appears. The Type, Object, and Name options are set for you automatically based on the object to which you are attaching the trigger and the trigger name you selected.
  4. In the PL/SQL Editor, enter the desired trigger code.
  5. Choose Compile to compile the trigger.
  6. Choose Close to dismiss the editor.

Creating a trigger in the Object Navigator

Creating a trigger in the PL/SQL Editor

Creating a trigger in the Layout Editor

PL/SQL Editor context

PL/SQL Editor commands

Setting trigger properties

About writing trigger code

About compiling triggers

Overview of trigger categories