Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Connect By .. Display Path
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
![]() |
![]() |