DECLARE
jobno BINARY_INTEGER
instno number
p_job_queue_processes VARCHAR2(512)
p_interval VARCHAR2(200)
p_next_date DATE
s_next_date VARCHAR2(50)
begin
select instance_number into instno from v$instance
-- jobno := 1512手工指定jobno
p_interval := 'trunc(sysdate,''HH24'')+(SELECT TRUNC(TO_CHAR(sysdate,''MI'')/30)/48 FROM DUAL)'-- 间隔
p_next_date := TO_DATE('20080910 13:45:00','RRRRMMDD HH24:MI:SS')--trunc(sysdate,'HH24') + 1/4/24-- 下次执行时间,date类型
s_next_date := to_char(p_next_date,'RRRR-MM-DD HH24:MI:SS')-- 下次执行时间,字符串类型
/* -- 创建新job
dbms_job.submit(jobno
, 'statspack.snap(7)'
, p_next_date -- trunc(sysdate,'HH24') + 1/24
, p_interval -- 'trunc(sysdate,''HH24'')+(SELECT TRUNC(TO_CHAR(sysdate,''MI'')/30)/48 FROM DUAL)'
, TRUE, instno)
*/
dbms_job.change(jobno, '要执行的程序名称' -- 比如statspack.snap-- 收集统计信息
, p_next_date
, p_interval
)--, TRUE, instno)
-- dbms_job.remove(jobno)--jobno -- 移除job
-- commit
end
--- 完成后,可以用select * from dba_jobs dj where dj.jobno=xxx 检查状态
what是填你要做的事情,what值啊'create or replace table zhenghong as (select * from TC_SFB_FILE)
这个才是what值
你把语句都全部写在那里面了
把这个建表的语句先写个过程再试试
Create Or Replace Procedure Pro123
Authid Current_User
Is
Begin
Execute Immediate (create table zhenghong as (select * from TC_SFB_FILE)
End
然后what里面填过程名pro123
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)