Re: Sequence usage

In article <4sfopu$7lr_at_mailhost.qsp.co.uk>, Steven_Dodsworth_at_qsp.co.uk says...
>
>In <31ea96db.1557249_at_news.inet.it>, stefano_at_mondobit.com (Stefano Ducati) writes:
>>I create a sequence with sqlplus
>>sqlplus>create sequence counter;
>>
>>But now I have to extract the numbers.
>>
>>How????
>>Thanx
>>
>>Stefano
>>
>
>select counter.nextval
>from dual;
>
>Bye,
>Steve

For what it is worth:

   select counter.CurrVal from dual;

Returns the current value.

I have several sequences and have yet to use this last

Regards

Autocratic newsserver stuff follows.
Autocratic newsserver stuff follows.
Autocratic newsserver stuff follows.
Autocratic newsserver stuff follows.
Autocratic newsserver stuff follows.
Autocratic newsserver stuff follows.
Autocratic newsserver stuff follows.
Autocratic newsserver stuff follows.