RE: HOW TO SET SEQUENCE VALUE
Date: Thu, 29 Mar 2012 06:49:25 -0500
Message-ID: <C5533BD628A9524496D63801704AE56D6ADD8111D6_at_SPOBMEXC14.adprod.directory>
CACHE_SIZE = 20? Create sequence NOCACHE
Chris Taylor
"Quality is never an accident; it is always the result of intelligent effort." -- John Ruskin (English Writer 1819-1900)
Any views and/or opinions expressed herein are my own and do not necessarily reflect the views of Ingram Industries, its affiliates, its subsidiaries or its employees.
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of jose soares
Sent: Thursday, March 29, 2012 6:24 AM
To: oracle_at_dunbar-it.co.uk
Cc: oracle-l_at_freelists.org
Subject: Re: HOW TO SET SEQUENCE VALUE
I can't understand these two queries:
select last)number from user_sequences where sequence_name='ANAGRAFICA_SEQ' last_number
24
select anagrafica_seq.nextval from dual
nextval
5
I expect to see 24 instead of 5.
last_number is not the same value incremented by nextval ?
j
Norman Dunbar wrote:
> 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?
>
>
-- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 29 2012 - 06:49:25 CDT