Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sequence numbers
It would be worth writing these 'business reasons' down. Then you can have a
discussion about how many of them stand up. If you were to suggest that each
NSN had to be the next prime number then I guess folk would balk at that.
How about the next even number? most business managers would see that as
arbitrary. Numbers divisible by 5? so why the next integer.
-- Niall Litchfield Oracle DBA Audit Commission UK "art" <art_teqNOSPAM_at_hotmail.com> wrote in message news:3cea0a75$1_1_at_nnrp1.news.uk.psi.net...Received on Tue May 21 2002 - 15:50:46 CDT
>
> "Galen Boyer" <galendboyer_at_yahoo.com> wrote in message
> news:uk7pyxeoq.fsf_at_rcn.com...
> > On Mon, 20 May 2002, art_teqNOSPAM_at_hotmail.com wrote:
> >
> > > I want NSN to remain sequential per product, and so cannot use an
> > > individual sequence for all products, and do not want a spearate
> > > sequence for each product as users can add and remove products
> > > arbitrarily.
> >
> > Why not use one sequence for the entire table. So what the numbers
> > aren't sequential per product. I mean, is that an issue?
> >
> > --
> > Galen deForest Boyer
> > Sweet dreams and flying machines in pieces on the ground.
>
> I can't do that for business reasons, or I would ;o)
> Thanks anyway.
>
>