Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: double linked list
Mikito Harakiri wrote:
> "--CELKO--" <71062.1056_at_compuserve.com> wrote in message
> news:c0d87ec0.0302011323.6b6e9e7f_at_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).
>
>
>
>
I think Joe's problem is spelled 'SQL SERVER'. CONNECT BY isn't in the Microsoft product.
Daniel Morgan Received on Sun Feb 02 2003 - 16:09:21 CST