Re: HOW TO SET SEQUENCE VALUE
Date: Thu, 29 Mar 2012 13:23:59 +0200
I can't understand these two queries:
select last)number from user_sequences where sequence_name='ANAGRAFICA_SEQ' last_number
select anagrafica_seq.nextval from dual
I expect to see 24 instead of 5.
last_number is not the same value incremented by nextval ?
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?
> PS. The email in that document is old, out of date, no longer works, you
> get my drift?