-
Book Overview & Buying
-
Table Of Contents
Oracle SQL Developer 2.1
By :
SQL Developer supports creating, editing, and debugging PL/SQL program units. Triggers, Functions, Procedures, and Packages are listed in the Connections navigator, and you can view the details of these by selecting and clicking on each to open the display editors. In this section, we'll look at each of these constructs in turn and at the dialogs and utilities associated with them.
Oracle database triggers fire when you manipulate or update data, update database objects (such as dropping a table), or on certain database events (such as logging on). SQL Developer provides a number of utilities and dialogs to simplify creating and working with triggers.
You can use the SQL Developer worksheet to write the PL/SQL code for the complete database trigger, without having the formal or, if you know the trigger structure very well, perhaps confining restrictions of a dialog. However, if you are a bit unfamiliar...
Change the font size
Change margin width
Change background colour