initially i checked last value of sequence from toad
value was 133 .
i connected to a new session and queried
select xyz.nextval from seqxyz ;
again i query xyz.currval from seqxyz ;
i was expecting output to be 133 ...
but got 124 am i mising any funda ...
gui=i don't understand what's really happening
The sequence has cached values - Toad is reading from the %_sequences view, in which the last_number increments by the cache value of the sequence. Keep selecting nextval from the sequence and when it reaches the value of last_number, you'll see last_number increment by however many sequence numbers are cached.
Thanks to all ,
i was just wondering from where toad is getting those values from .. ( the difference in values might have been in cached , which i am not seeing immediatlely through currval )