oracle定时执行sql,以及不自动执行定时任务的解决办法
一、创建存储过程CREATE OR REPLACE PROCEDURE test_proc IS --test_proc存储过程名称BEGIN delete fromxxxt where rownum < 100; --需要执行的sql语句 COMMIT;EXCEPTION WHEN OTHERS THEN DBMS_OUTPUT.PUT_LINE('Exception happened,data was rollback'); ...




