3 Replies Latest reply on Apr 14, 2013 7:10 AM by Amatu Allah Neveen Ebrahim

    tree in oracle 10g

      i want a tree node at run time
      i have this query
      select 1,

      e.ename ,
      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??