create sequence seq_name 
   start with 1
   increment by 1
   maxvalue 999999
   nocycle
   cache 20;


##</code><code>##

INSERT INTO table_name 
  ( id_no, col1, col2 )
values 
  ( seq_name.NEXTVAL, '$col1', '$col2' )