关于 Oracle自增列

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;