Multi master-detail query
- Thread starter Viorel
- Start date
What exactly do you want to see? Cna you give an example?
I give you the example from Toad. It's verry useful and i wish to find somme similar in PL/SQL Developer.
Master/Detail Table Browser
You can use this window to view or edit data from multiple tables, where foreign keys link the tables. 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, pick "EMPLOYEE" from the related tables dropdown list, select a department record, and the employee records will be displayed only for that department.
Note: If there is only one table relationship possible, Toad will automatically list the related tables for you, eliminating the need to select from the dropdown.
If the table relationships are set up properly, you can further drill down in the EMPLOYEE table to show employees managed by the current manager employee, by selecting "EMPLOYEE" again from Employee's related tables dropdown list. Selecting a manager employee record will now automatically display the employees managed by that manager. This is known as a circular table reference, where employee.manager_id is related to employee.employee_id.
There is currently a static limit of 5 related tables.
To access the Master/Detail Browser
Select ToolsMaster/Detail Browser.
In addition, you can further define master-detail relationships without having a foreign key.
Master/Detail Table Browser
You can use this window to view or edit data from multiple tables, where foreign keys link the tables. 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, pick "EMPLOYEE" from the related tables dropdown list, select a department record, and the employee records will be displayed only for that department.
Note: If there is only one table relationship possible, Toad will automatically list the related tables for you, eliminating the need to select from the dropdown.
If the table relationships are set up properly, you can further drill down in the EMPLOYEE table to show employees managed by the current manager employee, by selecting "EMPLOYEE" again from Employee's related tables dropdown list. Selecting a manager employee record will now automatically display the employees managed by that manager. This is known as a circular table reference, where employee.manager_id is related to employee.employee_id.
There is currently a static limit of 5 related tables.
To access the Master/Detail Browser
Select ToolsMaster/Detail Browser.
In addition, you can further define master-detail relationships without having a foreign key.
In PL/SQL Developer you can use the "Linked Query" button on the result set toolbar of the SQL Window after executing a select statement. This will show the parent and child tables, which you can select to query parent and child records of the current record. The results can be displayed in the same or in a new SQL Window (Click or Ctrl-Click).
Zulfiqar Ali
Member
is this requirement developed in new versions or still given linked query?
Last edited:
In the current version the Linked Query function will keep master and detail windows synchronized. If you move to a new master record, the detail windows will be be synchronized accordingly.
Similar threads
