Finding and eliminating circular references in a Table

From: Herbert <Herbert.Linseisen_at_faidor.de>
Date: 28 May 2002 00:25:13 -0700
Message-ID: <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 - 09:25:13 CEST

This message: [ Message body ]
Next message: J.P.: "Re: Finding and eliminating circular references in a Table"
Previous message: LordStinky©: "Oracle Intaller JRE hangs on RH 7.x"
Next in thread: J.P.: "Re: Finding and eliminating circular references in a Table"
Reply: J.P.: "Re: Finding and eliminating circular references in a Table"
Reply: Amy Ellis: "Re: Finding and eliminating circular references in a Table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message