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
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
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.
Re: creating tree in oracle form [message #399034 is a reply to message #399003] Mon, 20 April 2009 05:59 Go to previous message
Messages: 21146
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 Aug 18 05:58:00 CDT 2017

Total time taken to generate the page: 0.11624 seconds