1. 创建oracle序列
create sequence seq_test minvalue 1 maxvalue 9999999 start with 1 increment by 1 nocache;
2. 获取当前和下一个序列值
select seq_test.currval from dual;
select seq_test.nextval from dual;
1. 创建oracle序列
create sequence seq_test minvalue 1 maxvalue 9999999 start with 1 increment by 1 nocache;
2. 获取当前和下一个序列值
select seq_test.currval from dual;
select seq_test.nextval from dual;