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
34
|
Toad Pocket Reference for Oracle
Manipulating the Display, not the Query
Once you are satisfied with your SQL query, you are ready to
work with your query’s result set. You can execute the state-
ment once and then view many possible different permuta-
tions of your data’s formats, layouts, and even content.
SQL*Plus limits you to one result format; changing the lay-
outs and columns available requires you to rewrite and re-
execute your query.
Sort data, rearrange columns, and filter data
With Toad’s data grid, you can reorder the result set’s col-
umns by simply dragging and dropping the column headers
to the desired location. You can easily hide/unhide columns
by selecting Right Mouse
Select Columns on the grid. If
you are interested in only viewing a subset of the data, you
can filter the data by clicking on the column header drop-
down button and selecting Custom. Figure 6 shows an exam-
ple of using Excel-style filtering on the grid (the option must
first be activated, as described in the next section).
A single left-click on a column header in the data grid opens
a dialog to apply or remove an ascending or descending sort
on that column. When the operation is complete, the data
grid refreshes. A pointer displayed in the column header indi-
cates the direction of the sort.
You can remove the sort using the same left-click on the col-
umn header in the data grid. If you wish, you can also
remove ...
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