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: 20847
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: Thu Oct 27 02:46:15 CDT 2016

Total time taken to generate the page: 0.06731 seconds