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

Creating a Trigger in the Layout Editor

To create a trigger for an item in the Layout Editor:

  1. In the Layout Editor, select the item to which you want to attach the trigger.
  2. From the context menu, select SmartTriggers for a list of commonly used triggers for this object type. (In Windows, press the right mouse button to display the context menu.) For a full list of available triggers, follow steps 3 and 4.
  3. Select SmartTriggers | Other to open the Triggers List of values (LOV).
  4. Select the desired trigger name from the LOV, then click OK.
    The Type and Object options in the PL/SQL Editor are set automatically, according to the item that was selected when the editor is invoked. If there is already a trigger attached to the item, its name and code appear in the PL/SQL Editor.
  5. Enter the desired trigger code.
  6. Select Compile.
  7. Choose Close to dismiss the editor.

Creating a trigger in the PL/SQL Editor

Creating a trigger using Smart Triggers

Creating a trigger in the Object Navigator

PL/SQL Editor context

PL/SQL Editor commands

Setting trigger properties

About writing trigger code

About compiling triggers

Overview of trigger categories