Re: HOW TO SET SEQUENCE VALUE
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Thu, 29 Mar 2012 11:33:30 +0100
Message-ID: <4F743A7A.4030101_at_dunbar-it.co.uk>
On 29/03/12 11:15, jose soares wrote:
> Hi all,
>
> I'm trying to SET a sequence VALUE but seems it can't be done on oracle.
Oh yes it can! ;-)
Date: Thu, 29 Mar 2012 11:33:30 +0100
Message-ID: <4F743A7A.4030101_at_dunbar-it.co.uk>
On 29/03/12 11:15, jose soares wrote:
> Hi all,
>
> I'm trying to SET a sequence VALUE but seems it can't be done on oracle.
Oh yes it can! ;-)
> ...
> Is there a way to do the same thing in Oracle?
http://www.jlcomp.demon.co.uk/faq/resetseq.html
Cheers,
Norm.
PS. The email in that document is old, out of date, no longer works, you get my drift?
-- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 29 2012 - 05:33:30 CDT