Re: please help = pl/sql

JDC <tradeNOSPAM_at_localnet.com> wrote in message news:<vfi2e8h8dv8ba3_at_corp.supernews.com>...
> Hello all,
> I hope this newsgroup is the correct one for my question....
>
> essentially, I am trying to use PL/SQL to:
> search a table, and find records that are missing from the sequential
> order...
> *there could be double records, but there cannot be gaps**
> we need the value of the gaps printed to the screen

I'm going to read your mind and say that the reason you are doing this is some statutory requirement for no gaps in your invoice numbers. Otherwise why do it?

There are easier ways to do this, not necessarily more efficient. For starters you could do a loop and for each value in the loop do a select. No it's not the most efficient, but it's simple and as long as there is an index on invoice number should be "fast enough".

Good luck
Greg Received on Wed Jun 25 2003 - 08:02:13 CDT