--存储过程
create or replace PROCEDURE Sync_INFO_HISTORY IS
BEGIN
insert into tb_site_month
select * from TB_SITE where SITE_TIME<TRUNC(SYSDATE,'DD');
delete from TB_SITE where SITE_TIME<TRUNC(SYSDATE,'DD');
commit;
EXCEPTION
WHEN NO_DATA_FOUND THEN
rollback;
WHEN OTHERS THEN
rollback;
RAISE;
END Sync_INFO_HISTORY;