Re: Recursive select

I am not certain what you're attempting. But I think that, if you read up on CONNECT BY you'll have what you need.
Go to:

http://technet.oracle.com/docs/products/oracle8i/doc_index.htm

look under SQL Reference and Expressions.

<buurd_at_my-deja.com> wrote in message news:8116k5$sf9$1_at_nnrp1.deja.com...
> Hi... i want to ask a question like this:
> List all ancesters from person p. No only the closest one but ALL that
> is in the table. My table looks (somewhat simplified) like this
>
> table related(
> id int,
> name varchar2(30),
> parent int
> )
>
> Tia
>
> --
> Roland Carlsson
> Certified Java programmer
> Skövde
> Sweden
>
> Ps: I hope the solution isn't embarresbly simple ;-)
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Thu Nov 18 1999 - 10:16:11 CST