1. Oracle 查询自增列当前值
SELECT * FROM USER_SEQUENCES WHERE SEQUENCE_NAME='SEQ_MER';
2.
---创建自增序列
-- Create sequence
create sequence SEQ_MER
minvalue 1
maxvalue 999999999999
start with 1101
increment by 1
cache 20
cycle;
-- 更改序列 Student_stuId_Seq-- alter sequence Student_stuId_Seq increment by 2 minvalue 1 maxvalue 999999999; --获取序列自增ID -- select Student_stuId_Seq.Nextval 自增序列ID from dual; -- 删除序列 -- drop sequence Student_stuId_Seq;