Re: Query to return PK sequence gap ??

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 10 Oct 2007 10:51:12 GMT
Message-ID: <470caea0$0$1342$834e42db@reader.greatnowhere.com>

On Tue, 09 Oct 2007 12:15:50 -0700, Jagjeet Singh wrote:

> SQL> select rownum from (select 1 from dual connect by level <=
> &max_no)
> 2 minus
> 3 select emp_id from emp_test
> 4 /
>
> Enter value for max_no: 8
>
> ROWNUM
> ----------
> 2
> 4
> 6
> 7
> 8

This is the best version I've seen so far. My use of analytic functions was unnecessary. I was thinking of obtaining gaps in a different format, when I read the specification again.

-- 
http://www.mladen-gogala.com

Received on Wed Oct 10 2007 - 05:51:12 CDT