Re: How do we set new value for a SEQUENCE?

The first time you select, it return the last number was selected. If you alter the seq and assign
a new number to it, then that number will be selected the first time you issue a select from the seq

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 Mon Feb 21 2000 - 20:55:40 CET