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

Creating a Trigger in the PL/SQL Editor

To create a trigger in the PL/SQL Editor:

  1. In the PL/SQL Editor, set the Type option to Trigger.
  2. Set the Object options to specify the object (form, block, or item) for which you are defining the trigger.
    For example, to attach the trigger to a block, set the first Options drop-down List to the name of the block, and set the second drop-down List to Block Level.
  3. Write the trigger code.
  4. Choose Compile to compile.
  5. Choose Close to dismiss the editor.

Creating a trigger in the Object Navigator

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