Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: question about sequences.

Re: question about sequences.

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Mon, 17 Feb 2003 09:42:45 +0500
Message-ID: <b2pp7t$1fjfhg$1@ID-127142.news.dfncis.de>


All,

I was playing on my test database (8174, solaris8) just to see it myself. Below you can see my actions:

campus_at_romka> create sequence testseq
  2 minvalue 1 maxvalue 1000 start with 1 increment by 1;

Sequence created.

Elapsed: 00:00:00.10
campus_at_romka> select testseq.nextval from dual;

   NEXTVAL


         1

Elapsed: 00:00:00.10
campus_at_romka> select count(*) from dual;

  COUNT(*)


         1

Elapsed: 00:00:00.10
campus_at_romka> insert into dual values('Y');

1 row created.

Elapsed: 00:00:00.00
campus_at_romka> select count(*) from dual;

  COUNT(*)


         2

Elapsed: 00:00:00.10
campus_at_romka> select testseq.nextval from dual;

   NEXTVAL


         2

Elapsed: 00:00:00.10

But I can't force last select statement to return 2 rows. Did I miss something?

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com
Received on Sun Feb 16 2003 - 22:42:45 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US