Re: SELECT & recursion

Bart Wakker wrote:
> On 2006-03-21, vc <boston103_at_hotmail.com> wrote:
>
> > You are confused -- the way 'connect by' behaves in your examples is
> > just the opposite to what you've described.
> >
>
> Indeed.
>
> The DB2 solution using WITH, doesn't work for oracle b.t.w.: the result is
> ORA-32031: illegal reference of a query name in WITH clause.

That's because Oracle does not implement the standard recursive query (a la DB2). Received on Wed Mar 22 2006 - 16:18:30 CET