Home » Developer & Programmer » Forms » creating tree in oracle form
creating tree in oracle form [message #399003] Mon, 20 April 2009 04:39 Go to next message
irfankundi786@yahoo.com
Messages: 269
Registered: February 2009
Location: pakistan
Senior Member

I want to create tree in oracle form
but i found query on net that is
SELECT 1, LEVEL, ename, '', TO_CHAR(empno)
FROM emp
CONNECT BY PRIOR empno = mgr
START WITH job = 'PRESIDENT'
i can not understant this query ,
what deos the prior empno=mgr
what is meaning by start with job='president'
please explain these two steps with detail.
thanks
Re: creating tree in oracle form [message #399034 is a reply to message #399003] Mon, 20 April 2009 05:59 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Such questions can be answered by studying documentation. Link can be found in OraFAQ Forum Guide.
Previous Topic: Problem when create sequence
Next Topic: Make User Page
Goto Forum:
  


Current Time: Fri Dec 09 21:35:45 CST 2016

Total time taken to generate the page: 0.18224 seconds