Re: question about sequences.

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