Re: Query to return PK sequence gap ??

From: Gokul <gokulkumar.gopal_at_gmail.com>
Date: Fri, 12 Oct 2007 20:50:02 -0700
Message-ID: <1192247402.766253.106480@y27g2000pre.googlegroups.com>

Read about this on AskTom. This is not a problem on 10g.

SQL> select * from v$version;

BANNER

---

Oracle9i Enterprise Edition Release 9.2.0.5.0 - 64bit Production PL/SQL Release 9.2.0.5.0 - Production
CORE 9.2.0.6.0 Production
TNS for Solaris: Version 9.2.0.5.0 - Production NLSRTL Version 9.2.0.5.0 - Production

SQL> select level from dual connect by level < 5;

     LEVEL

---

         1

SQL> select * from (select level from dual connect by level < 5);

     LEVEL

---

         1
         2
         3
         4

SQL> Received on Fri Oct 12 2007 - 22:50:02 CDT