How to Create Master Detail With Interactive Grid in Oracle Apex?
Set Row Pagination As Select List In Interactive Grid Oracle APEX
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/preview-9.gif)
We need to create two Interactive Grids. Lets take DEPT and EMP tables for interactive GRID.
Grid 1.
SELECT * FROM DEPT;
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-206-1024x354.png)
Grid 2.
SELECT * FROM EMP;
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-205-1024x354.png)
Now setup Master details configurations.
- Goto Details Grid
- Select Master Grid region
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-203-1024x441.png)
- Goto the Deptno Column
- Select the master Grid primary key Column(DEPTNO)
![](https://blogs.ontoorsolutions.com/wp-content/uploads/2022/12/image-204-1024x398.png)