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

Report message to a moderator

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: 21823
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.

Report message to a moderator

Previous Topic: Problem when create sequence
Next Topic: Make User Page
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 03 22:39:52 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.