Re: Dynamically settting sequence start values?
From: Peter-Paul van de Beek <P.P.v.d.Beek_at_a2000.com>
Date: Mon, 07 Dec 1998 17:46:00 +0100
Message-ID: <366C0648.D1C1882A_at_a2000.com>
Date: Mon, 07 Dec 1998 17:46:00 +0100
Message-ID: <366C0648.D1C1882A_at_a2000.com>
Michael Spoonauer wrote:
> Does anyone know if it is possible to set the starting value for a sequence
Yes it is:
Create sequence <sequence_name> start with <your_start_number>;
>
> 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
Received on Mon Dec 07 1998 - 17:46:00 CET