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
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