Toad for Oracle Unleashed

SQL Editor Output Area

The data grid has a tool palette that enables the user to scroll up or down the returned rows, add rows, and delete rows (see Figure 3.6). Notice the light at the cursor along the bottom of the SQL Editor screen (see the cursor position in Figure 3.7). If this is red, then the data in this data grid cannot be changed and the commit/rollback/add/delete rows buttons will be grayed out. If the pseudo column ROWID was selected in the SQL, then this light will be green and the commit/rollback/add/delete rows palette will not be grayed out and the data can be changed.

FIGURE 3.6 Data Tool palette

FIGURE 3.7 Toad data grid ...