Skip to Main Content

Oracle Apex Hierarchical Data View

4164142Jan 6 2020 — edited Jan 6 2020

I am creating a pretty basic CRUD application with Oracle Apex. I simply want to create a hierarchy based on some logic that spans 4 tables all on one page. In our current application which we are trying to convert to Oracle Apex we have a list of nodes that when we click on them we can display their children tables in the main view.

Lets say we have 4 tables, each with Primary Keys that relate to one another. How do I display certain values from these tables on the page all at the same time? I have tried some of the wizards that Apex provides but with no success. I think it will have to be custom PL/SQL logic. The data has to be in a certain order as well.

1

2

3

4

How can I create a view similar to this?

pastedImage_0.png

pastedImage_3.png

Comments
Post Details
Added on Jan 6 2020
1 comment
479 views