Re: Should/Can I use Sequence for this ?

Hi,
Each department has its own counter.
e.g :
0100001
0100002
0200001
0200002
How can I do it with sequence.

Thank you,
xtanto

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1096226709.145021_at_yasure>...
> xtanto wrote:
>
> > Hi Gurus,
> >
> > I have to maintain computer generated document numbering where the
> > number format is :
> >
> > xx123456789
> >
> > xx : is the department code
> > 123456789 : document number counter per department
> >
> > How can I maintain this number ?
> > Can I use sequence for this ? or should I manually maintain(increment)
> > it in a document highest number table per dept code ?
> >
> > Thank you for your help,
> > xtanto
>
> As Jim says a sequence is perfect for it ... but with one caveat. Your
> design violates the most basic rules of data normalization. The 'xx'
> department code belongs in a column of its own.
>
> In addition to just adhering to the normalization rule you will find
> that every query you do doesn't include SUBSTR(doc_id, 1, 2) which
> will improve performance and scalability.
Received on Mon Sep 27 2004 - 08:40:49 CDT