Oracle APEX Master Details Tutorial with Examples

The lastest Oracle APEX version at present (18-10-2015) is 5.0.1, a pity of this version is that it still does not allow you to create 2 Tabular-Form on the same page. It means that you can't create Master & Details on the same page in which both of them are in Tabular-Form. However, Oracle APEX development team as promised that this limitation will be overcome in the upcoming version. And so you need to wait patiently. Now working with Master-Details you have 2 options:

Below slider imagine show you the website displays Master-Detail with Master in Form type, Details is Tabular-Form.You can easily create with the help of the Wizard.

Below slider imagine show you the website displays Master-Detail with Master in Form type, Details is Table, create and modify records of Detail on another page. You can easily create with the help of the Wizard.

Create Master-Details with the help of the Wizard

Select Master table is DEPT

Select detail table is EMP.

Wizard will ask you "Include master report?":

1. If you choose Yes, Wizard will create page list of records of Master which displays in tabular form ((Just see) and a page contain Master in Form and Details in Tabular-Form.
2. However, if you choose No, only one page will be created with the Master in Form and Details in Tabular-Form.

Enter:

Master-Details has been created, you can test application.

You can modify the items displayed on the Tabular-Form into "Select List" or LOV, in Oracle Apex Tabular Form tutorial, I have guide specifically on this issue.

There are 2 pages which are created when you create a Master-Details by Wizard, as I mentioned above Oracle APEX does not allow you to create 2 Tabular-Form on the same page, at least for the current version (Oracle APEX 5.0.1), we hope that this limitation will be overcome in the next versions.