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.
05-19-2004, 11:18 PM
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 )