Re: managing sequences

From: Norman Dunbar <Norman_at_RE-MO-VE.BountifulSolutions.co.uk>
Date: Tue, 28 Oct 2003 08:52:16 +0000
Message-ID: <pan.2003.10.28.08.52.16.410470@RE-MO-VE.BountifulSolutions.co.uk>

On Mon, 27 Oct 2003 17:36:44 +0100, Morgan GOARIN wrote:

> Hi
> I am using sequences in a PL/SQL stored procedure and I need to reset my
> sequence. Does anybody know the way to re-initialize an Oracle sequence
> without having to drop and recreate it ?
> Thanks in advance
> Morgan Goarin

Here you are :

http://www.jlcomp.demon.co.uk/faq/resetseq.html

Enjoy !

Cheers,
Norman.

-- 
Delete the obvious bit from my email address to reply by email.

Received on Tue Oct 28 2003 - 02:52:16 CST