Use the Master/Detail browser to view or edit data from multiple tables, snapshots, views or queries linked by foreign keys or a user-defined master-detail relationship. This is typical of a database setup from an Entity/Relationship diagram, where one table's objects are related to another table's objects by a linking field or fields.
For example, you could start with the DEPARTMENT table, and display details. Select a department record in the Master grid, and the detail grid will display employee records for that department only. If multiple tables are linked by foreign keys, you can add additional details beneath the first.
To access the Master/Detail Browser
|»||From the Database menu, select Report | Master/Detail Browser.|
To the left of the Master Detail Browser is the Master Detail Navigator. As you add detail tables, they are added to the navigator under the original table. Using the navigator can make it much easier to control very detailed sets of master/details.
Within the navigator, you can hide or display the schema name and delete detail nodes.
You can use the navigator to find the grid for a specific detail table.
To find a detail
|»||In the Navigator, click on the node for the detail you want to view.|
Note: In the Master Detail browser, the grid for that detail flashes in the lower grid pane.
You can set Toad to display only one grid at a time by checking the Single Grid Mode box on the Master/Detail toolbar. Use the navigator to select which grid you want to see.
You can generate XML output from a master-detail relationship. From the master-detail grids, you can send a query to the Editor that will generate the output. Output will be created in XML Form, one XML document per row.
This feature is available only in Oracle 9iR2 and newer, and when the Master-Detail relationship consists of one master and one detail.
To generate XML output
Toad creates an XML document for each row in the master dataset, with each XML document containing all corresponding detail rows.
To save XML output to disk
Before you can add details, you first need to select the master object for the relationship view.
To select a master object
The grid populates with the contents of your selected object.