--重建序列
DECLARE
CURSOR CUR IS select sequence_name from all_sequences where sequence_owner='NGUSER';
BEGIN
DBMS_OUTPUT.put_line('清除sequence...');
FOR C IN CUR LOOP
DBMS_OUTPUT.put_line('sequence_name:'||C.sequence_name);
execute immediate 'drop sequence '||C.sequence_name;
END LOOP;
END;
-- Create sequence
create sequence SEQ_T_XXFBB
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;
DECLARE
CURSOR CUR IS select sequence_name from all_sequences where sequence_owner='NGUSER';
BEGIN
DBMS_OUTPUT.put_line('清除sequence...');
FOR C IN CUR LOOP
DBMS_OUTPUT.put_line('sequence_name:'||C.sequence_name);
execute immediate 'drop sequence '||C.sequence_name;
END LOOP;
END;
-- Create sequence
create sequence SEQ_T_XXFBB
minvalue 1
maxvalue 999999999999999999999999999
start with 1
increment by 1
cache 20;