Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: question about sequences.
"Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
news:E2F6A70FE45242488C865C3BC1245DA703507BFF_at_lnewton.leeds.lfs.co.uk...
> Afternoon Ryan,
>
> Nah - you got it right :o)
>
> 64 bit 8.1.7.4 on HPUX 11.00 64bit :
>
> SQL> CREATE SEQUENCE TEST;
> SEQUENCE created
>
> SQL> SELECT * FROM dual;
> DUMMY
> -----
> X
> 1 ROW selected
>
> SQL> SELECT TEST.NEXTVAL FROM dual;
> NEXTVAL
> ----------
> 1
> 1 ROW selected
>
> SQL> INSERT INTO dual VALUES ('Y');
> 1 ROW inserted
>
> SQL> SELECT * FROM dual;
> DUMMY
> -----
> X
> Y
> 2 ROWS selected
>
> SQL> SELECT TEST.NEXTVAL FROM dual;
> NEXTVAL
> ----------
> 2
> 3
> 2 ROWS selected
>
>
> SQL> DELETE FROM dual WHERE dummy = 'Y';
> 1 ROWS deleted
>
> SQL> DROP SEQUENCE TEST;
> SEQUENCE dropped
>
> Regards,
> Norman.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
> -----Original Message-----
> From: Ryan [mailto:rgaffuri_at_cox.net]
> Posted At: Monday, February 17, 2003 12:25 PM
> Posted To: server
> Conversation: question about sequences.
> Subject: Re: question about sequences.
>
>
>
>
> >> guess I got the question wrong. anyone have any idea what the correct
> answer
> >> is?
>
>
thanks... Received on Mon Feb 17 2003 - 08:48:04 CST