Re: How do we set new value for a SEQUENCE?
From: Tom Zamani <tomz_at_redflex.com.au>
Date: Tue, 22 Feb 2000 10:10:15 +1100
Message-ID: <88sh5g$pf$1_at_perki.connect.com.au>
Date: Tue, 22 Feb 2000 10:10:15 +1100
Message-ID: <88sh5g$pf$1_at_perki.connect.com.au>
[Quoted] You can not alter the next vale of a sequence, you need to drop it and
recreat it.
tom
Ingvar Larsson <ingvar.larsson_at_gil-support.se> wrote in message
news:R7fs4.7403$al3.97821_at_newsc.telia.net...
> We have a sequence counter we wants to give new value for the next
sequence
> value.
>
> Example
>
> SELECT seqcnt.nextval FROM dual; returns 1
>
> Than we executes something like
> ALTER SEQUENCE seqcnt NEXTVAL 20;
>
> and the next
> SELECT seqcnt.nextval FROM dual; returns 20
>
> How do we do this?
>
> /Ingvar
>
>
>
>
Received on Tue Feb 22 2000 - 00:10:15 CET