| add a node in oracle tree [message #582130] |
Sat, 13 April 2013 12:58 |
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
|
Senior Member |
|
|
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??
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
