1、创建序列
create sequence 序列名
minvalue 1000001
maxvalue 9999999
start with 1000002
increment by 1
cache 20
cycle
order;
2、查询序列是否存在
select * from user_sequences where sequence_name='序列名';
1、创建序列
create sequence 序列名
minvalue 1000001
maxvalue 9999999
start with 1000002
increment by 1
cache 20
cycle
order;
2、查询序列是否存在
select * from user_sequences where sequence_name='序列名';