SQL>create sequence s_Id
SQL>INCREMENT BY 1
SQL>START WITH 1
SQL>MAXVALUE 99999999;
SQL>insert into table_name
SQL>values(s_Id.nextval,col1...)
SQL>INCREMENT BY 1
SQL>START WITH 1
SQL>MAXVALUE 99999999;
SQL>insert into table_name
SQL>values(s_Id.nextval,col1...)
INSERT INTO my_table(id,...) values(seq.NEXTVAL,...)