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

Creating a Trigger in the Object Navigator

To create a trigger in the Object Navigator:

  1. In the Object Navigator, position the cursor on the Triggers node under the form, block, or item to which you are attaching the trigger.
    For example, if you are attaching a trigger to a button, click on the Triggers node under the name of the button.
  2. Choose Edit | Create to invoke the Triggers List of values (LOV).
  3. Select the desired trigger name from the LOV, then click OK.
    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. Press Compile PL/SQL to compile the trigger.
  6. Choose Close to dismiss the editor.

Creating a trigger in the PL/SQL Editor

Creating a trigger in the Layout Editor

Creating a trigger using Smart Triggers

PL/SQL Editor context

PL/SQL Editor commands

Setting trigger properties

About writing trigger code

About compiling triggers

Overview of trigger categories