Re: Finding and eliminating circular references in a Table

How about a simple implicit cursor like:

select *
from table1
where pnr in
  (select pnr_parent
   from table1)

Herbert.Linseisen_at_faidor.de (Herbert) wrote in message news:<822c67f8.0205272325.185aa145_at_posting.google.com>...
> I got a Table that contains Parts. These Parts can contain other Parts.
>
> The Table is like this:
>
> pnr_parent , pnr,
>
>
> How can I find self references that go over several levels ?
>
>
> System: Oracle DB, PL/SQL
Received on Tue May 28 2002 - 22:06:24 CEST