Connect By .. Display Path

From: <stelios4_at_my-deja.com>
Date: Wed, 28 Jul 1999 17:30:12 GMT
Message-ID: <7nnemp$6eb$1@nnrp1.deja.com>

I am using Oracle version 7.3.4.3. I am having difficulty getting the list I need. I need the select statement I enter to output the path to the file I need. For example... I need:

Top Folder

Intermediate FOlder

       Bottom Folder
           File1

Top Folder

Intermediate FOlder

       Bottom Folder
           File2

etc.....

I am using this command for now

select distinct dataid, LPAD(' - ',25*(Level-1))||name name, parentid from tbl_temp
where datatype||subtype = 1140
start with dataid > 2000
connect by dataid = prior parentid
order by parentid, childcount

Any assistance is greatly appreciated.

Steve

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Jul 28 1999 - 12:30:12 CDT