Query to return PK sequence gap ??

From: <krislioe_at_gmail.com>
Date: Tue, 09 Oct 2007 02:33:42 -0700
Message-ID: <1191922422.816953.115940@k79g2000hse.googlegroups.com>

Hi All,

I want to make a query that return PK sequence gap. How to do that ?

here is my DDL :
Create Table EMP_TEST(
emp_id number primary key,
emp_name varchar2(30)
);

insert into EMP_TEST values (1, 'john');
insert into EMP_TEST values (3, 'didier');
insert into EMP_TEST values (5, 'cole');

The query will have two bind variables : :emp_id_from and :emp_id_to

If I pass 1 to :emp_id_from and 7 to :emp_id_to , the query should return :

PK _GAP

---

2
4
6
7

Thank you for your help,
xtanto Received on Tue Oct 09 2007 - 04:33:42 CDT