Observe Oracle data with Master-Detail Browser

In order to launch it, proceed to the Database menu and click Master-Detail Browser. Alternately, right-click the required database objects in the Database Explorer window, select Send to, and click Master-Detail Browser.

Master-Detail Browser, which is available in dbForge Studio for Oracle, is a convenient tool that helps to view and analyze related data in:

  • Parent tables or views
  • Related child tables or views
  • Self-referencing tables

A special master-detail document with the *.mdet extension is created upon launching the Master-Detail Browser.

Working in Design View

Launch the dbForge Studio, and you will see an Oracle explorer window (Database Explorer) on the left. You can drag tables and views from this window onto your diagrams.

Arrows between tables or views show existing relations between them. Additionally, it is possible to create links between columns - simply drag a column from one object to a column in the other object that you want to link. Right-click the link to change its direction or remove it completely.

Master-Detail Browser for Oracle: Working in Design View

Working in Data View

You can switch to the Data tab to observe your data.

If you want to view data according to specific criteria, enter the WHERE condition in the corresponding field under the diagram. In this case, only the data that meets these criteria will be displayed.

In case your table contains large amounts of data and you do not need to view all of them, you can indicate a fetch limit in the corresponding field under the diagram. The amount of memory, which is required to display the results, will be reduced.

Whenever it is required, you can switch to the Design tab to go back to the Design View.

Master-Detail Browser for Oracle: Working in Data View

Sorting Data in Master-Detail Browser

Simply click the required column header to sort data by a particular column, change the sorting direction, or stop sorting. Every subsequent click changes the sorting operation.

Master-Detail Browser for Oracle: Sorting Data

Filtering Data in Master-Detail Browser

Filtering allows to display a subset of table records, which meet a specific criterion. When filtering is applied to a table, the displayed records are restricted to those that meet your current filtering criterion.

To filter data against single or multiple columns, select a column value from the filter drop-down list. Additionally, you can choose a suggested filter or set up a custom one using the Custom AutoFilter window.

Master-Detail Browser for Oracle: Filtering Data

Your ultimate Master-Detail Browser for Oracle

Try dbForge Studio for Oracle to get all the advantages of the Master-Detail Browser, where all of your data can be conveniently visualized in its entirety with Design and Data application views. Check the available editions of dbForge Studio for Oracle to see which one best suits your needs and requirements. You can always address our Master-Detail Browser documentation to get acquainted with the workflow in detail.

dbForge Studio for Oracle

Make your daily work faster and easier with the most intelligent Oracle IDE

Availability in the editions of dbForge Studio for Oracle


Master-Detail Browser