Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!newsfeed1.earthlink.net!newsfeed.earthlink.net!news.maxwell.syr.edu!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.theory,comp.databases.rdb,comp.databases.oracle.misc Subject: Re: double linked list Date: Sun, 02 Feb 2003 14:09:21 -0800 Organization: EXE Message-ID: <3E3D9711.C3E93E08@exesolutions.com> X-Mailer: Mozilla 4.79 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 References: <2ee07259.0301280744.582e4b7c@posting.google.com> <2ee07259.0301290412.5eb3290a@posting.google.com> <2ee07259.0301310449.2cbc1468@posting.google.com> Content-Type: multipart/alternative; boundary="------------682B663512286B4B29D28D7C" Cache-Post-Path: yasure!unknown@mud43.drizzle.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 83 Xref: newsfeed1.easynews.com comp.databases.theory:24571 comp.databases.rdb:2104 comp.databases.oracle.misc:92613 X-Received-Date: Sun, 02 Feb 2003 15:09:00 MST (news.easynews.com) --------------682B663512286B4B29D28D7C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Mikito Harakiri wrote: > "--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"... I think Joe's problem is spelled 'SQL SERVER'. CONNECT BY isn't in the Microsoft product. Daniel Morgan --------------682B663512286B4B29D28D7C Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Mikito Harakiri wrote:

"--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"...

I think Joe's problem is spelled 'SQL SERVER'. CONNECT BY isn't in the Microsoft product.

Daniel Morgan --------------682B663512286B4B29D28D7C--