17,382
社区成员




create or replace procedure "bak_Info_Pro"
is
/*--str_sql varchar2(500);*/
begin
insert into t_hp_tips_bak select * from t_hp_tips t where t.invalid_date<sysdate;
/*判断是否插入备份表成功,若成功则删除原表中过期记录
--execurte immediate str_sql;*/
delete from t_hp_tips t where t.invalid_date<sysdate;
commit;
Exception
when others then
rollback;
end bak_Info_Pro;