How do we set new value for a SEQUENCE?

From: Ingvar Larsson <ingvar.larsson_at_gil-support.se>
Date: Mon, 21 Feb 2000 18:05:37 GMT
Message-ID: <R7fs4.7403$al3.97821_at_newsc.telia.net>

[Quoted] [Quoted] We have a sequence counter we wants to give new value for the next sequence value.

[Quoted] Example

[Quoted] [Quoted] SELECT seqcnt.nextval FROM dual; returns 1

Than we executes something like
[Quoted] 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 - 19:05:37 CET