Re: Query to return PK sequence gap ??

On Tue, 09 Oct 2007 02:33:42 -0700, krislioe_at_gmail.com wrote:

>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

I was wondering if this could be done with a hierarchical query. It would seem to show the borders, however, ot the missing numbers.

Just curious.

B. Received on Tue Oct 09 2007 - 08:47:17 CDT