Re: Dynamically settting sequence start values?

>Does anyone know if it is possible to set the starting value for a sequence
>I am about to drop and recreate based on the returned value from a select
>statement against a table or group of tables?
>
>I'm in Oracle 7.3.x.
>
>Thanks,
>Mike Spoonauer
>

There is an initial value setting when you create an index, look in the manual.

Also - neat trick to avoid dropping and recreating a sequence (loses grants etc, then), is to dynamically alter the increment (either positive or negative), select a value, set reset the increment back. Works great.

Dan Hekimian-Williams Received on Mon Dec 07 1998 - 05:05:42 CET