Re: Re: Recursive SQL

From: <radioaktiv_at_my-deja.com>
Date: Thu, 10 Jun 1999 15:39:14 GMT
Message-ID: <7jom70$l11$1@nnrp1.deja.com>

Looks like a homework assignment to me, so i'll give you a hint... Chris wrote:

>Look at the START WITH and CONNECT BY clauses for an Oracle select
>statement.

>hope this helps.

Thank you, _but_

1st: It does not work with START WITH because I do not know the starting point (there are several starting points). If omit this clause, Oracle uses all rows in the table as root rows but I do not want that.
2nd: START WITH and CONNECT BY are parsing the tree from the root o the top, I want to do it viceversa.

So I still have the same problem (and it is no homework assignment :)

Knut

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jun 10 1999 - 10:39:14 CDT