Skip to Main Content

Java Development Tools

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!

Duplicate nodes in Tree table for self referencing relationship

944338Oct 23 2012 — edited Nov 25 2012
Hi,

Consider the standard EMP table in scott schema. I need to get EMPLOYEE - MANAGER Hierarchical relationship. But its showing me duplicate nodes as well.

[ADF Tree output|http://s11.postimage.org/4cg7taysz/Mgr_Emp_Tree.png]

I want to show Tree starting with "7839 King" only. I have used a self-referencing link for the same but no luck.

How can I achieve that.

Thanks,
Manu

Edited by: Manu Batham on Oct 23, 2012 8:12 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 23 2012
Added on Oct 23 2012
2 comments
151 views