Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Query to return PK sequence gap ??
On Fri, 12 Oct 2007 10:53:16 -0000, "Vladimir M. Zakharychev"
<vladimir.zakharychev_at_gmail.com> wrote:
>On Oct 10, 5:59 pm, Brian Tkatch <N/A> wrote:
>> On Wed, 10 Oct 2007 15:30:15 +0200, codadilupo
>>
>> <codadil..._at_operamail.com> wrote:
>> >Brian Tkatch wrote:
>>
>> >> But this solution does not work in 9i.It does work in 10g.
>>
>> >It doesn't work in 9.0.1 but it works in 9.2.
>>
>> I stand corrected.
>>
>> I quicky tested by running: select 1 from dual connect by level <=
>> 10; on its own. That does not work in 9.2, but does work in 10g. As a
>> subquery, however, it works even in 9.2.
>>
>> B.
>
>Works for me in 9.2.0.8.
SQL> SELECT * FROM V$VERSION; BANNER
SQL> SELECT 1 FROM Dual CONNECT BY LEVEL <= 10;
1
1
SQL> SELECT * FROM V$VERSION; BANNER
SQL> SELECT 1 FROM Dual CONNECT BY LEVEL <= 10;
1
1 1 1 1 1 1 1 1 1 1
10 rows selected.
B. Received on Fri Oct 12 2007 - 08:09:54 CDT
![]() |
![]() |