Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!g44g2000cwa.googlegroups.com!not-for-mail
From: jkstill@gmail.com
Newsgroups: comp.databases.oracle.server
Subject: Re: Multi Level Tree Structure
Date: 9 Sep 2005 10:01:33 -0700
Organization: http://groups.google.com
Lines: 11
Message-ID: <1126284295.907739.163910@g44g2000cwa.googlegroups.com>
References: <1126248797.589318.36160@z14g2000cwz.googlegroups.com>
NNTP-Posting-Host: 63.163.28.170
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1126285299 18834 127.0.0.1 (9 Sep 2005 17:01:39 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 9 Sep 2005 17:01:39 +0000 (UTC)
In-Reply-To: <1126248797.589318.36160@z14g2000cwz.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.7.8) Gecko/20050511 Firefox/1.0.4,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g44g2000cwa.googlegroups.com; posting-host=63.163.28.170;
   posting-account=mGBwVA0AAAB1cByzi862Uvf-W5zcEu4D
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:251187

Stephane Faroult wrote an excellent article on using connect-by to
create tree structures.

If you are an IOUG member you will find it at
http://www.ioug.org/client_files/members/select_pdf/04q1/CNCTBY.pdf

If not, google has a cached HTML version at
http://64.233.161.104/search?q=cache:JSAjaph7_fsJ:www.selectonline.org/viewFile.cfm%3FreturnPage%3Dhttp://www.ioug.org/client_files/members/select_pdf/04q1/CNCTBY.pdf+stephane+faroult+tree+fruit&hl=en

The PDF however is much easier to read.