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.

Image

FIGURE 3.6 Data Tool palette

FIGURE 3.7 Toad data grid ...

Get Toad for Oracle Unleashed now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.