Duplicate nodes in Tree table for self referencing relationship
944338Oct 23 2012 — edited Nov 25 2012Hi,
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