Re: Query to return PK sequence gap ??

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Sat, 13 Oct 2007 19:08:13 -0400
Message-ID: <5nd1efFhn4m1U1@mid.individual.net>

DA Morgan wrote:

> Gokul wrote:

>> SQL> select * from (select level from dual connect by level < 5);
>>
>> LEVEL
>> ----------
>> 1
>> 2
>> 3
>> 4
>>
>> SQL>
>>

>
> Works properly in 11.1.0.6.
Shouldn't this return a cycle error?
(because the same row in DUAL is returned multiple times).

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Received on Sat Oct 13 2007 - 18:08:13 CDT