Тема уже подымалась :-)
create sequence SEQ1 minvalue 1 increment by 1;
select Seq1.Nextval,Seq1.Nextval from dba_objects where rownum < 5;
create sequence SEQ2 minvalue 1 increment by 2;
select Seq2.Nextval, Seq2.CurrVal + 1 from dba_objects where rownum < 5;
даст совершенно ожидаеммый результат:
SQL> create sequence SEQ1 minvalue 1 increment by 1;
Sequence created.
SQL> select Seq1.Nextval,Seq1.Nextval from dba_objects where rownum < 5;
NEXTVAL NEXTVAL
---------- ----------
1 1
2 2
3 3
4 4
SQL>
SQL> create sequence SEQ2 minvalue 1 increment by 2;
Sequence created.
SQL> select Seq2.Nextval, Seq2.CurrVal + 1 from dba_objects where rownum < 5;
NEXTVAL SEQ2.CURRVAL+1
---------- --------------
1 2
3 4
5 6
7 8