create table dateTemp(chardate varchar(8));
delete dateTemp;
select chardate from dateTemp;
begin
for v in 20090601..20090630 loop
insert into dateTemp values(v);
end loop;
commit;
end;
/
begin
for v in (select chardate from dateTemp order by chardate desc) loop
delete from partition(P200907)
where to_char(XX59_RVRT_DT, 'yyyymmdd') >= v.chardate;
commit;
end loop;
commit;
end;
/
阅读(3066) | 评论(0) | 转发(0) |
