Re: resetting a sequence

From: Andrew Babb <andrewb_at_mail.com>
Date: Tue, 23 Mar 1999 09:55:36 +0800
Message-ID: <36F6F498.DA7BD18A@mail.com>

Steven,

You could use the DBMS_SQL package to construct an ALTER SEQUENCE or CREATE SEQUENCE command. I had to develop this logic for a sequence that needed to be reset on the 1st of the month, and it worked, but grants were a little bit difficult to recreate, due to our application standards.

Hope this helps,
Andrew

Steven Egberghs wrote:

> Hi there,
> How can I reset a sequence, from within an application or stored procedure.
> Oracle8, NT4
>
> Thanks
> Steven
Received on Mon Mar 22 1999 - 19:55:36 CST