oracle数据库序列号自增

//创建序列号 从1000  到  99999999 

create sequence seq_a minvalue 1000 maxvalue 99999999 start with 1000 increment by 1 nocache;  

//查询序列号
select seq_a.nextval from dual; 

//向数据库中新增数据   序列号递增---》  seq_a.nextval  
insert into yw_sqjhmx(sqjhno,sqmxno,shdwno,lrrq,sbrq,shrq,jhlx,jhlxmx,gs,zddw,wzno,wzmc,xhgg,jldw,dj,sqsl,flag,jhyno,sqry,flfs,sbdwno,sqlb,zdcg,sydwno,hzsqno,xzbz,cgsl,gydno,gydsl,zdsl,zdflfs,memo) values('0',seq_a.nextval,'0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0','0.00','0','0','0')