
Data Grid
|
37
from its initial fetch. If you pull the scrollbar down to the
bottom, this will ask Toad to retrieve all the records. For
large result sets, this can be a very memory-intensive opera-
tion. Toad may appear to freeze, but it is actually bringing
back all the records and constructing the grid contents to
allow you to browse the data.
Scroll left to right
When you are viewing datasets that contain many columns,
it can be quite frustrating to have to scroll back and forth to
be able to view the particular information you want. Toad’s
data grid allows you to “fix” a column or group of columns.
Anchoring a column on the lefthand side of the data grid can
make it easier to track information when you are doing a lot
of scrolling.
To anchor a column, click in a column to select it. Then
right-click and select Fix Column to fix the selected column.
The selected column is anchored to the left. To move a col-
umn out of the fixed area, click and drag it to the right of the
bold fixed-column divider bar.
Editing Data from the Data Grid
Toad’s advanced data editors simplify the updating of your data.
No more remembering the proper TO_DATE or TO_CHAR
functions for your INSERT/UPDATE/DELETE statements!
For you to edit data via the data grid, the result set must be
editable. There are several ways to achieve an editable result
set (the status is displayed in the data grid panel with either a
green or a red ...