I have a certain problem in hier trees.
I have an orgn table with orgid(primary key) and orgname.
I have another table dept with deptno (primary key), dname and orgid (foreign key).
I have to create a hierarchical tree with these 2 tables.
Creating a tree by constructing a view from the two tables is not possible as 'connect by' does not allow joins.
I made nodes from the org table using 'Add Tree Node built in.
I added data under the main nodes using 'Add Tree data ' built in.
Though the main tree nodes were displayed with the (+) sign where children exist, the child nodes refuse to be displayed.
Could u help me with this?
I have an orgn table with orgid(primary key) and orgname.
I have another table dept with deptno (primary key), dname and orgid (foreign key).
I have to create a hierarchical tree with these 2 tables.
Creating a tree by constructing a view from the two tables is not possible as 'connect by' does not allow joins.
I made nodes from the org table using 'Add Tree Node built in.
I added data under the main nodes using 'Add Tree data ' built in.
Though the main tree nodes were displayed with the (+) sign where children exist, the child nodes refuse to be displayed.
Could u help me with this?