oracle 序列使用

create sequence seq_pzh201801 increment by 1 start with 1 maxvalue 10000 -- increment为正即正序 为负及逆序，默认为

select  seq_pzh201801.nextval from dual --查找序列下一数 每次查找自增1

alter sequence seq_pzh201801 increment by -1  --将序列当前值减小   

select * from user_sequences  --查找所有序列