序列操作

1.查询所有序列

select SEQUENCE_OWNER,SEQUENCE_NAME from dba_sequences where sequence_owner='用户名'; 

2.查询序列下一个数字

select 序列名.NEXTVAL from dual;

3.修改当前值

alter sequence se_1 increment by -2; 
修改步进的值，然后查询一次，
 select seq.nextval from dual;
然后再把步进修改回去，

alter sequence se_1 increment by 1;