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
42
|
Toad Pocket Reference for Oracle
one you want to use from View Options Data Grids
Data via the option:
Use the older version of the Data Print Grid
When checked, this tells Toad to use the old Toad Print
Grid dialog box. If unchecked, Toad uses the newer
Report Link Designer (this is the default).
Working with Data
Toad has many different utilities for making data manipula-
tion less of a chore. This section briefly discusses four of the
most powerful ones. For more detailed information, consult
Toad Help or the Toad for Oracle User’s Guide.
Master Detail Browser
You can use the Master Detail Browser window to view or
edit data from multiple tables in which foreign keys link the
tables. For example, you could start with the DEPARTMENT
table, pick “EMPLOYEE” from the related table’s dropdown
list, and select a department record; the employee records
will be displayed only for that department. There is a static
limit of five related tables that you may have open in the
browser at one time.
The Master Detail Browser is accessible via Tools
Master
Detail Browser.
Compare Data wizard
You can use Toad’s Compare Data wizard to compare data
between tables within different schemas or different data-
bases. This can be useful for comparing the data found in a
production and test environment, for example. Toad allows
you to configure the datasets you wish to compare (e.g.,
selecting the columns, ordering
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