Re: Query to return PK sequence gap ??

Comments embedded.
On Oct 9, 4:33 am, krisl..._at_gmail.com wrote:
> Hi All,
>
> I want to make a query that return PK sequence gap.

Why?

> How to do that ?
>

Any number of ways; two have already been given you.

> 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

Again, why do you 'need' to find this 'information'? What purpose does it serve?

David Fitzjarrell Received on Tue Oct 09 2007 - 07:42:39 CDT