dbXpert for Oracle

Features Review

Master Detail Browser - make it easy to view data in master-detail structure

• Unlimited number of detail datasets can be added
• Detail datasets can be created in any configuration: Linear Structure:

  
  Master - Detail - Detail - Detail - Detail

  
  Tree Structure

              - Detail

  Master               - Detail

              - Detail

                           - Detail - Detail

• The master, detail dataset can be a table or view
• You can apply the filtering or sorting using the WHERE/ORDER tabs.
• All details of your master-detail configuration can be saved and retrieved.
• You can click the record in the resultset, the corresponding detial resordsets will be refreshed.
• You can edit the resultset directly, including insert/update/delete records.

Master Detail Browser - view the SQL text of the master detail statements

Master Detail Browser - copy the text to Workspace to edit manually, press Ctrl+M to rerun it.

The following shows two sample SQL statements for the Master Detail Queries. To join the master and detail, just simply put the bind varaible with the format :<MASTER TABLE ALIAS>__<FIELD_NAME> (double underline between the alias and the field name). Please be reminded that the Master SQL statments must be put prior to the detail SQL statements.

Example 1:

SELECT JOB_ID , JOB_TITLE , MIN_SALARY , MAX_SALARY
FROM HR.JOBS JOBS

SELECT EMPLOYEE_ID , FIRST_NAME , LAST_NAME , EMAIL , PHONE_NUMBER , HIRE_DATE , JOB_ID , SALARY , COMMISSION_PCT , MANAGER_ID , DEPARTMENT_ID
FROM HR.EMPLOYEES EMPLOYEES
WHERE :JOBS__JOB_ID = JOB_ID

SELECT EMPLOYEE_ID , START_DATE , END_DATE , JOB_ID , DEPARTMENT_ID
FROM HR.JOB_HISTORY JOB_HISTORY
WHERE :JOBS__JOB_ID = JOB_ID

Example 2:

SELECT REGION_ID , REGION_NAME
FROM HR.REGIONS REGIONS

SELECT COUNTRY_ID , COUNTRY_NAME , REGION_ID
FROM HR.COUNTRIES COUNTRIES
WHERE :REGIONS__REGION_ID = REGION_ID

SELECT *
FROM HR.LOCATIONS LOCATIONS
WHERE :COUNTRIES__COUNTRY_ID = COUNTRY_ID