Creating a Trigger With the Object Browser Page

Previous

Next

You can create and update triggers in the database with Object Browser.

To create a trigger with the Object Browser page:

1. Log in to the Database Home Page. See "Logging in to the Database Home Page". To run the examples in this guide, log in as user HR with your password for the HR account.

2. Click the Object Browser icon on the Database Home Page.

3. Click the Create button, and select Trigger from the list.

4. Enter the name of the table (employees) that the trigger activity is based on and click the Next button. You can also select a table name from list.

5. In the Trigger Name field, enter the trigger name (emp_salary_trigger). The the Preserve Case box should be unchecked.

6. From the Firing Point list, select the firing point (AFTER).

7. From the Options list, select an option (update of).

8. From the Column list, select a column (salary).

9. Check the For Each Row option. Do not enter anything in the When field.

10. In the Trigger Body field, enter the code for the trigger body. See Example: Creating a Database Trigger WIth the AFTER Option. Note that if a database object is referred to in the trigger body code, then that object must exist for the trigger to be valid.

11. Click the Next button.

12. Click the SQL button to view the SQL statements for creating the trigger.

13. Click the Finish button to complete the action.