Re: question about sequences.

"Roman Mirzaitov" <rmirzaitov_at_kt.kg> wrote in message news:b2pu1i$1f88qm$1_at_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
>
>
>

guess I got the question wrong. anyone have any idea what the correct answer is? Received on Mon Feb 17 2003 - 06:24:35 CST