--创建序列
CREATE SEQUENCE hydmdh_seq
INCREMENT BY 1
START WITH 1
MAXVALUE 9999999
NOCYCLE NOCACHE;
--使用序列
select hydmdh_seq.NEXTVAL from dual
--删除序列
DROP SEQUENCE hydmdh_seq;
oracle序列
最新推荐文章于 2024-09-04 21:28:23 发布
--创建序列
CREATE SEQUENCE hydmdh_seq
INCREMENT BY 1
START WITH 1
MAXVALUE 9999999
NOCYCLE NOCACHE;
--使用序列
select hydmdh_seq.NEXTVAL from dual
--删除序列
DROP SEQUENCE hydmdh_seq;