RE: HOW TO SET SEQUENCE VALUE
Date: Thu, 29 Mar 2012 06:49:25 -0500
CACHE_SIZE = 20? Create sequence NOCACHE
"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.
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
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
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?
Received on Thu Mar 29 2012 - 06:49:25 CDT