Re: Query to return PK sequence gap ??

On Wed, 10 Oct 2007 15:30:15 +0200, codadilupo <codadilupo_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. Received on Wed Oct 10 2007 - 08:59:13 CDT