Re: HOW TO SET SEQUENCE VALUE

From: jose soares <jose.soares_at_sferacarta.com>
Date: Thu, 29 Mar 2012 13:23:59 +0200
Message-ID: <4F74464F.4070106_at_sferacarta.com>

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

Received on Thu Mar 29 2012 - 06:23:59 CDT