Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Apex tree leaf element

8b44976f-beb6-421c-a04c-efe667fedc83Oct 15 2018 — edited Oct 16 2018

Hello,

I have an apex tree which retrieves all the properties in the database

SELECT status, level, name, icon, id, tooltip, link

FROM table_properties

WHERE ...

START WITH...

CONNECT BY PRIOR id = pid

ORDER SIBLINGS BY ...

and I want to be able to click on this table's leaf nodes and see some columns which are also in table_properties (for example creation date and user). These 2 fields should appear as child nodes of the leaf nodes.

Is there any way I could do that?

Thank you for the help!

Comments
Post Details
Added on Oct 15 2018
3 comments
578 views