Re: Should/Can I use Sequence for this ?

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Sun, 26 Sep 2004 16:35:14 GMT
Message-ID: <6dC5d.265250$mD.230695@attbi_s02>

"xtanto" <krislioe_at_gmail.com> wrote in message news:e1c9bd55.0409260827.62c00a56_at_posting.google.com...
> 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

Sequence is perfect for it.
Jim Received on Sun Sep 26 2004 - 11:35:14 CDT