Re: Search the initial parents from recursive SQL

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 20 Dec 2001 16:51:35 +0100
Message-ID: <f6242u4ib08mvpnrqt41lvumji4o82tlje@4ax.com>

On Thu, 20 Dec 2001 10:52:25 +0100, "Isma" <Ismael_at_NOSPAMiballo.com> wrote:

>HI,
>
>I've got a query I can't resolve.
>
>Exple
>
>parent child
>A B
>
>B C
>
>C E
>
>D F
>
>From E, is it possible by a query to wind up to A ?
>The same for F(which gives D) !!!
>
>
>Thanks
>

Just reverse the column names in the connect by clause and that is all.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Dec 20 2001 - 09:51:35 CST