Re: Query to return PK sequence gap ??

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