Re: Sequence usage

From: Steve Dodsworth <Steven_Dodsworth_at_qsp.co.uk>
Date: 1996/07/16
Message-ID: <4sfopu$7lr_at_mailhost.qsp.co.uk>#1/1


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


| any similarity 'tween my opinions and that |
|  of my employers are purely hypothetical   |
|     and should give no cause for alarm     |
 --------------------------------------------
Received on Tue Jul 16 1996 - 00:00:00 CEST

Original text of this message