Tree
Tree is Oracle PL/SQL package for building hierarchical tree of two or more master-detail tables. Each table can be plain or hierarchical itself. Manages large amount of data. For using in client software.
Setup
Download and unpack this zip file.
Using SQL*PLus run setup.sql.
Demo
Grant select privileges on scott.emp and scott.dept to user, who owns client_util package.
Run test_scott_dept_emp.sql and/or test_scott_emp.sql scripts to demonstraite how the package works.
 |