sys.v_$sequences (approximately) is an undocumented
dynamic view which describes the currently cached
sequences, including either the last value that was granted
or the next value that will be granted - can't remember
which at the moment
--
Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk
Yong Huang wrote in message <8s7lr3$nl1$1_at_news.sinet.slb.com>...
>By the way, does anybody know a way to show the current or next
>sequence-generated number without really incrementing the sequence? Select
>mysequence.currval from dual won't work unless nextval is already used
above
>it. Select mysequence.nextval from dual will increment it and there's no
way
>to decrement (except for dropping and recreating the sequence).
>
>Yong Huang
>yhuang_at_indigopool.com
>
>Van Messner <vmessner_at_bestweb.net> wrote in message
>news:LlrF5.6101$mC.427999_at_monger.newsread.com...
>> Use dba_sequences for information about sequences.
>>
>> Van
>>
>>
>> "Luke" <lucas_at_link.net.id> wrote in message
news:zRpF5.9030$K6.60150_at_news...
>> > hi,
>> > anybody tell me, how to show sequence in sql plus ?
>> >
>> > tks
>> > Luke
>> >
>> >
>>
>>
>
>
Received on Wed Oct 18 2000 - 06:44:28 CDT
