Browsing Master-Detail Data

When doing relational database work (regardless of whether you are a DBA, developer, or business analyst), the time comes when you must be able to inspect and sometimes modify data. Of course, you could use TOAD’s SQL Editor window with its data grid, but today’s highly normalized databases would make “one table at a time” efforts tedious and error-prone. What’s generally necessary is a screen where you can easily see a table, its related tables, and their synchronized data (that is, focus on parent sets and focus on children to the same base record). TOAD has just such a screen in its Master Detail Browser, shown in Figure 9.1 and located on the main menu at Tools, Master Detail Browser.

Figure 9.1. TOAD Master ...

Get TOAD® Handbook now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.