一个简单存储过程的测试
--创建表
create table test001 (id number(4));--表建好后,创建PROCEDURE
CREATE OR REPLACE PROCEDURE INSERT_SP AS
BEGIN
INSERT INTO test001 values(2);
COMMIT;
END INSERT_SP ;
--建立JOB:
DECLARE
job_no_ NUMBER;
BEGIN
DBMS_JOB.SUBMIT(job_no_,
'INSERT_SP;',
sysdate,
'TRUNC(sysdate)+1+09/24+0.01');
-- 20/24 每天晚上9点
COMMIT;
END;
--查询JOB:
select
job,last_date,last_sec,next_sec,total_time,interval,what
from user_jobs;