Tree is Oracle PL/SQL package client_util for building hierarchical tree of one table, two or more master-detail tables.
Each table can be "plain" or hierarchical itself. Opens only one level of hierarchy when expanding the branch of the tree for best performance. Manages large amount of data. For using in client software.