获取序列（oralce/存储过程）

获取所有序列创建语句（从1开始）

版本： Oracle 19c

select 'CREATE SEQUENCE_NAME ' || sequence_name || ' MINVALUE 1 MAXVALUE 9223372036854775807 INCREMENT BY 1 START WITH 1 CACHE 2000 NORDER CYCLE;' as CREATE_SEQ_SQL from user_sequences;

获取所有序列创建语句（从当前序列值开始/存储过程）

declare
  seq_currval number;
begin
  for seq in (select * from user_sequences) loop
    execute immediate 'select ' || seq.SEQUENCE_NAME || '.nextval from dual' into seq_currval;
    DBMS_OUTPUT.PUT_LINE('CREATE ' || seq.SEQUENCE_NAME || ' MINVALUE 1 MAXVALUE 9223372036854775807 INCREMENT BY 1 START WITH ' || seq_currval || ' CACHE 2000 NORDER CYCLE;');
  end loop;
end;