java调用oracle序列方法

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;