https://blog.csdn.net/a19881029/article/details/8961053
https://blog.csdn.net/u010999809/article/details/82911918
创建sequence:
create sequence seq_test
minvalue 1
maxvalue 21
start with 1
increment by 1
cache 20
cycle
order;
查找指定sequence:
select * from all_sequence where sequence_name like '%xxx%';
查看sequence的下一值:
select seq_test.nextval from dual;
删除sequence:
drop sequence seq_test;