Show Detail Dataset
The Toad team has sprinkled the Master Detail Browser around in Toad. This button opens an additional data grid for the data of any object related to the primary table data being displayed. The data in the detail dataset follows the referential relationship defined by the existing primary/foreign key constraints.
Notice in Figure 5.10 that the DEPT table is the primary data grid, and when you click the Show Detail Dataset button, the EMP table data appears for the current row in the primary set.
FIGURE 5.10 DEPT/EMP detail datasets
Tip
The author uses the Show Detail Dataset button, along with Export Dataset, to save related ...
Get Toad for Oracle Unleashed now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
