帮忙看看这个存储过程
CREATE OR REPLACE procedure event_into_history
as
begin
insert into t_dbsensor_sqlmoni_history select * from t_dbsensor_sqlmoni
where checktime < to_date(to_char(sysdate,'yyyymmdd') || '060000','yyyymmddhh24miss');
delete from t_dbsensor_sqlmoni
where checktime < to_date(to_char(sysdate,'yyyymmdd') || '060000','yyyymmddhh24miss');
commit;
end;
/
就是将当前系统时间之前的数据备份到历史表里同时删除原来表里的数据
编译没出错,但是执行了之后数据并没有备份过去
是存储过程有错吗?