Home » Developer & Programmer » Forms » add a node in oracle tree
add a node in oracle tree [message #582130] Sat, 13 April 2013 12:58
irfankundi786@yahoo.com
Messages: 203
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??
Previous Topic: Create lov and recordgroup dynamically
Next Topic: Multi language in forms 6i
Goto Forum:
  


Current Time: Fri Apr 18 19:40:10 CDT 2014

Total time taken to generate the page: 0.08471 seconds