Creating PL/SQL Triggers

To create a trigger:

  1. Select Viewthen choose Connection Navigator.
  2. Expand Database.
  3. Select a connection and expand it.
  4. In the connection, right-click New Trigger to open the Create Trigger dialog.
  5. Enter parameters and select options to define the view.
  6. Click OK to create the trigger. It will be added to the Triggers node.
  7. Double-click the trigger to open it in the text editor.
  8. Edit the BEGIN ... END statement to define the function of the trigger.
  9. When finished, choose Filethen choose Save from the main menu to save the trigger.

For more information about parameters and options in step 6, click Help in the dialog, or see the CREATE TRIGGER section of the Oracle Database SQL Reference at http://www.oracle.com/technology/documentation/database10g.html.

Related topics

Creating, Editing and Using PL/SQL Programs

 

Copyright © 1997, 2004, Oracle. All rights reserved.