Oracle 序列的创建和使用
创建序列
create sequence seq_a minvalue 1000 maxvalue 99999999 start with 1000 increment by 1 nocache;
create sequence seq_a minvalue 1000 maxvalue 99999999 start with 1000 increment by 1 nocache;
查询序列
select seq_a.nextval from dual;
select * from user_sequences
select sequence_name from USER_SEQUENCES;
删除序列
drop sequence your_sequence_name
drop sequence seq_a
drop sequence seq_a
为每张表生成对应的序列