Re: [beginner] sequence
From: Guido Konsolke <GK_at_oblivion.com>
Date: Tue, 25 Nov 2003 12:48:21 +0100
Message-ID: <1069760096.758721_at_news.thyssen.com>
Date: Tue, 25 Nov 2003 12:48:21 +0100
Message-ID: <1069760096.758721_at_news.thyssen.com>
"Linux_at_Marco" <mmueller_at_XXXXX3denter.com> wrote...
> Hi!
>
> I have a question on the sequence, actually our...terrible
database...has
> the sequence at the value 4 (in a ipotetic table) but the value that
are in
> the table are with id (5,6,7,8,9,...30...) how can i forward the
sequence to
> the value 30 ? ...
>
> Thanks....
>
> Marco
>
Hi Marco,
choose one of the following:
- Select the sequence's NEXTVAL 26 times.
- Modify the sequence's increment value to fit your need (remember to put it back in the original state after you finished your work).
hth,
Guido
Received on Tue Nov 25 2003 - 12:48:21 CET