Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!sjc70.webusenet.com!news.webusenet.com!wn11feed!wn13feed!worldnet.att.net!204.127.198.203!attbi_feed3!attbi.com!rwcrnsc51.ops.asp.att.net.POSTED!not-for-mail From: "Mikito Harakiri" Newsgroups: comp.databases.theory,comp.databases.rdb,comp.databases.oracle.misc References: <2ee07259.0301280744.582e4b7c@posting.google.com> <2ee07259.0301290412.5eb3290a@posting.google.com> <2ee07259.0301310449.2cbc1468@posting.google.com> Subject: Re: double linked list Lines: 30 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 Message-ID: NNTP-Posting-Host: 12.236.17.145 X-Complaints-To: abuse@attbi.com X-Trace: rwcrnsc51.ops.asp.att.net 1044165100 12.236.17.145 (Sun, 02 Feb 2003 05:51:40 GMT) NNTP-Posting-Date: Sun, 02 Feb 2003 05:51:40 GMT Organization: AT&T Broadband Date: Sun, 02 Feb 2003 05:51:40 GMT Xref: newsfeed1.easynews.com comp.databases.theory:24570 comp.databases.rdb:2103 comp.databases.oracle.misc:92597 X-Received-Date: Sat, 01 Feb 2003 22:50:58 MST (news.easynews.com) "--CELKO--" <71062.1056@compuserve.com> wrote in message news:c0d87ec0.0302011323.6b6e9e7f@posting.google.com... > >> Currently I figure to use > > SELECT cs, cb, level > FROM link_t > START WITH cb > IN (SELECT cb > FROM link_t > WHERE cs = 'A') > CONNECT BY PRIOR cb = cs; > > that will return a tree containing all paths with the root as the > common starting point. << > > It returns a sequential file that represents a table and that > represernation depends on the order of the records (they are no > longer rows in a table). Looks like we won't see a "connect-by" chapter in your book;-) In addition to http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&selm=bdf69bdf.02 08011026.9caa07a%40posting.google.com I would mention that there is a striking syntactic and semantic similarity between "connect-by" and "group-by"...