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
|
39
Access the Single Record View
You can access the Single Record View by clicking on the
book icon in the upper left of the data grid. The Single
Record View window opens and displays your current record
on a single panel. This view reflects any sorting and filtering
of data and any hiding or reordering of columns that have
been set in the data grid. Many users appreciate being able to
use the option Sort columns in record view dialog available
from View
Options Data Grids Data to sort their col-
umns for this view.
Saving/Sending Data in Various Formats
Once you have assembled, sorted, and filtered your data, you
will have numerous output functions available to you.
The Save As function is available both from the Grid menu
on the Toad Menu toolbar and from any Toad data grid’s
Figure 7. Popup Editor for a XML datatype
40
|
Toad Pocket Reference for Oracle
Data Right Mouse menu. You can choose to save the data
in the data grid in a number of different formats by selecting
these options:
Delimited Text (you choose the delimiting character)
Fixed Field Spacing
HTML Table
Insert Statements
SQL Loader
XLS File (Excel)
XLS Instance (Toad creates an Excel file within the cur-
rent Excel instance running on your machine)
XML (plain)
XML (with XSL)
As you change formats, you may notice ...
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