Oracle批量删除数据脚本

Oracle批量清理数据脚本，利用游标自动化删除数据JOB

create sequence seq_id   
minvalue 1
maxvalue 99999999999999999999
start with 1
increment by 1
cache 20;

 
begin
    for i in 1..1000000 loop
         insert into t1 values(seq_id.nextval,'name'||i);
    end loop;
end;
/



declare
    cursor cur is (select structureid from t_cc_structure_bak where time >= to_date('20220301', 'yyyymmdd'));
    type t1 is table of NUMBER(16) index by binary_integer;
    v_t1 t1;
begin
    open cur;
    loop
        fetch cur bulk collect into v_t1 limit 4000;
        forall i in v_t1.first..v_t1.last 
             delete t_cc_structure_bak
             where structureid=v_t1(i);
        exit when cur%notfound;
        commit;
    end loop;
    close cur;
end;

/