oracle序列

--创建序列
CREATE SEQUENCE hydmdh_seq
INCREMENT BY 1
START WITH 1
MAXVALUE 9999999
NOCYCLE NOCACHE;

--使用序列
select hydmdh_seq.NEXTVAL from dual

--删除序列
DROP SEQUENCE hydmdh_seq;