
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