orcale序列 CREATE SEQUENCE

1.新建

CREATE SEQUENCE SEQ_PRO_KF

MINVALUE 1 MAXVALUE 999 INCREMENT BY 1 START WITH1 CACHE 20 ORDER  NOCYCLE ;

2.删除

drop sequence SEQ_PRO_KF

3.获取序列 

select SEQ_PRO_KF.nextval from dual