Skip to Main Content
Toad Pocket Reference for Oracle, 2nd Edition
book

Toad Pocket Reference for Oracle, 2nd Edition

by Jeff Smith, Patrick McGrath, Bert Scalzo
May 2005
Intermediate to advanced content levelIntermediate to advanced
130 pages
4h 31m
English
O'Reilly Media, Inc.
Content preview from Toad Pocket Reference for Oracle, 2nd Edition
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle PL/SQL Language Pocket Reference, 5th Edition

Oracle PL/SQL Language Pocket Reference, 5th Edition

Steven Feuerstein, Bill Pribyl, Chip Dawes
Oracle RMAN 11g Backup and Recovery

Oracle RMAN 11g Backup and Recovery

Robert Freeman, Matthew Hart
Oracle Database 11g A Beginner's Guide

Oracle Database 11g A Beginner's Guide

Ian Abramson, Michael Abbey, Michael Corey

Publisher Resources

ISBN: 9780596529079