Re: SELECT & recursion

From: Bart Wakker <bhawa_at_web.de>
Date: Wed, 22 Mar 2006 12:33:39 +0000
Message-ID: <slrne22h13.cbq.bhawa_at_bhawa.web.de>


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. Received on Wed Mar 22 2006 - 13:33:39 CET

Original text of this message