Re: SQL question

From: Andy Hassall <andy_at_andyh.co.uk>
Date: Wed, 04 May 2005 23:49:50 +0100
Message-ID: <c6ki715ntt90abcoeiu7p6lg5kp6tjichu@4ax.com>

On Thu, 05 May 2005 00:32:43 +0200, Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote:

>On Wed, 04 May 2005 17:49:41 -0400, Walt
><walt_askier_at_YerBootsyahoo.com> wrote:
>
>>Not sure what others are talking about with regard to self refrencing
>>being disallowed.
>
>Apparently CONNECT BY doesn't ring a bell. Has been available since at
>least version 5.

But the OP was asking about foreign keys, not hierarchical queries. Just because it'd cause a loop if you did a CONNECT BY doesn't mean that self-references aren't allowed.

>And no: circular references are not possible with CONNECT BY.

Even that's not true in 10g, CONNECT BY has a NOCYCLE flag that lets you query cyclic data.

-- 
Andy Hassall / <andy@andyh.co.uk> / <http://www.andyh.co.uk>
<http://www.andyhsoftware.co.uk/space> Space: disk usage analysis tool

Received on Wed May 04 2005 - 17:49:50 CDT