oracle sql序列的简单例子
-- Create sequence
create sequence TEST_DATA_SQC
minvalue 1
maxvalue 9999999999999999999999999999
start with 1
increment by 1
cache 20;
可以通过sql取序列的当前值和下一值
---当前值
SELECT TEST_DATA_SQC.CURRVAL FROM DUAL;
---下一个值
SELECT TEST_DATA_SQC.NEXTVAL FROM DUAL;