Re: Finding and eliminating circular references in a Table
From: J.P. <jp_boileau_at_yahoo.com>
Date: 28 May 2002 11:24:53 -0700
Message-ID: <7e388bc3.0205281024.222e9291_at_posting.google.com>
Date: 28 May 2002 11:24:53 -0700
Message-ID: <7e388bc3.0205281024.222e9291_at_posting.google.com>
Look at the "CONNECT BY" command. It's documented in the Oracle docs.
JP
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 - 20:24:53 CEST