This discussion is archived
3 Replies Latest reply: Apr 14, 2013 12:10 AM by Amatu Allah RSS

tree in oracle 10g

khan786 Newbie
Currently Being Moderated
i want a tree node at run time
i have this query
select 1,
level,

e.ename ,
null,
e.empno
from emp e
connect by prior e.empno = e.mgr
start with mgr is null

in this query the king is first node after that jones under the jones node the scott node layed now i want to add new node under the scott node ...scott is parent of new
how i can do this??

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points