Oracle定时调用存储过程:
DECLARE
l_jobid NUMBER;
BEGIN
sys.dbms_job.submit(job => l_jobid,
what => 'begin excel_process_pkg.excel_job;
end;',
next_date => SYSDATE,
INTERVAL => 'SYSDATE+1/1440');
COMMIT;
[color=blue]'SYSDATE+1/1440':表示1分钟执行一次(一天是1440分钟)[/color]
取整数的几个Oracle自带方法:
select trunc(3.655) from test_table; --直接取整(结果:3)
select ceil(3.155) from test_table; --进位取整(结果:4)
select round(3.655) from test_table; --四舍五入取整(结果:4)
select round(3.655,2) from test_table;--四舍五入保留小数位(结果:3.66)
DECLARE
l_jobid NUMBER;
BEGIN
sys.dbms_job.submit(job => l_jobid,
what => 'begin excel_process_pkg.excel_job;
end;',
next_date => SYSDATE,
INTERVAL => 'SYSDATE+1/1440');
COMMIT;
[color=blue]'SYSDATE+1/1440':表示1分钟执行一次(一天是1440分钟)[/color]
取整数的几个Oracle自带方法:
select trunc(3.655) from test_table; --直接取整(结果:3)
select ceil(3.155) from test_table; --进位取整(结果:4)
select round(3.655) from test_table; --四舍五入取整(结果:4)
select round(3.655,2) from test_table;--四舍五入保留小数位(结果:3.66)