----删除5天前的日志记录
EXEC_SQL:='DELETE FROM BA_PUB_ETL_LOG WHERE ETL_DATE<TO_CHAR(SYSDATE-5,''YYYY-MM-DD'')' ;
EXECUTE IMMEDIATE (EXEC_SQL);
COMMIT;
oracle 之删除5天前的日志
最新推荐文章于 2022-08-29 17:53:41 发布
----删除5天前的日志记录
EXEC_SQL:='DELETE FROM BA_PUB_ETL_LOG WHERE ETL_DATE<TO_CHAR(SYSDATE-5,''YYYY-MM-DD'')' ;
EXECUTE IMMEDIATE (EXEC_SQL);
COMMIT;