question about sequences.

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 17 Feb 2003 14:10:37 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703507BFF@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?
Received on Mon Feb 17 2003 - 08:10:37 CST