Oracle sequence creation and cyclic auto-increment values

Use sys to log on to Oracle SQL> conn sys/root as sysdba for sequence creation and auto-increment of loops; create sequence SQL> create sequence test_seq maxvalue 9 increment by 2 start with 1 cache 2 cycle; create corresponding test table SQL> create table test_table (next number, curr number ); insert test data (10 times in a loop) SQL> insert into test_table (next, curr) values (test_seq.nextval, test_seq.currval); Retrieve Data: SQL> select * from testseq1; next curr ---------- 1 1 3 3 5 5 7 7 9 9 11 11 13 13 15 17 17 19 19