Re: Query to return PK sequence gap ??

From: Brian Tkatch <N/A>
Date: Fri, 12 Oct 2007 09:09:54 -0400
Message-ID: <2gsug3937p63j4etamm2bbv74jonv64347@4ax.com>

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

---

Oracle9i Enterprise Edition Release 9.2.0.8.0 - Production PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for Linux: Version 9.2.0.8.0 - Production NLSRTL Version 9.2.0.8.0 - Production

SQL> SELECT 1 FROM Dual CONNECT BY LEVEL <= 10;

         1

---

         1

SQL> SELECT * FROM V$VERSION; BANNER

---

Oracle Database 10g Express Edition Release 10.2.0.1.0 - Product PL/SQL Release 10.2.0.1.0 - Production
CORE 10.2.0.1.0 Production
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production

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