Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: please help = pl/sql

Re: please help = pl/sql

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Wed, 25 Jun 2003 09:09:33 -0700
Message-ID: <3EF9C93D.BD5E4C8@exxesolutions.com>


Greg Forestieri wrote:

> 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

Interesting mind read.

My read is that there is a huge data integrity problem if the same invoice number can exist more than once and the entire thing needs to be redesigned. But, given the limited information we have, who can say?

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)
Received on Wed Jun 25 2003 - 11:09:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US