Creating PL/SQL Triggers

To create a trigger:

1. Select View | 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 folder.
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 File | 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, available from the Oracle Technology Network (OTN) at http://www.oracle.com/pls/db92/db92.homepage.

Related topics

Creating, Editing and Using PL/SQL Programs

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