Swapnil

• Jul 28th, 2005

 

it is used to get a tree type structure in data. 
 
say like hierarchy in a company.. employees reporting their managers etc..

Atal

 Profile Answers by Atal 

• Sep 16th, 2005

 

 The start with .. connect by clause can be used to select data that has a hierarchical relationship (usually some sort of parent->child (boss->employee or thing->parts).

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 8th, 2006

 

select a.*, level from emp a

start with mgr is null

connect by mgr = prior empno;