oracel触发器,每隔一天触发一次?谁有示例?急用. oracel触发器,每隔一天触发一次?谁有示例?急用. 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 这是要用JOB来做,你先写个存储过程 DECLARE X NUMBER;BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what => '存储过程名' ,next_date => to_date('01/06/2008 00:00:00','dd/mm/yyyy hh24:mi:ss') ,interval => 'TRUNC(SYSDATE)) + 1' ,no_parse => FALSE ); SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));COMMIT;END;/ 这是要用JOB来做,你先写个存储过程 DECLARE X NUMBER;BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what => '存储过程名' ,next_date => to_date('01/06/2008 00:00:00','dd/mm/yyyy hh24:mi:ss') ,interval => 'TRUNC(SYSDATE)) + 1' ,no_parse => FALSE ); SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));COMMIT;END;/ 这个要用JOB来实现DECLARE X NUMBER;BEGIN SYS.DBMS_JOB.SUBMIT ( job => X ,what => '存储过程;' ,next_date => to_date('01/06/2008 00:00:00','dd/mm/yyyy hh24:mi:ss') ,interval => 'TRUNC(SYSDATE) + 1' ,no_parse => FALSE ); SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));COMMIT;END;/ 我在pl/sql下declare job_city_day2t_city_orders number;begin sys.dbms_job.submit( job =>job_city_day2t_city_orders, what=>'proc_city_date2t_city_orders', next_date=>to_date('14-05-2008 17:00:00','dd-mm-yyyy hh24:mi:ss'), interval => 'trunc(sysdate + 1)', no_parse => false); sys.dbms_output.put_line('Job Number is :' || to_char(job_city_day2t_city_orders)); commit;end;出现ORA-06550: 第 1 行, 第 122 列: PLS-00103: 出现符号 "END"在需要下列之一时: := . ( @ % ;符号 ";" 被替换为 "END" 后继续。ORA-06512: 在 "SYS.DBMS_JOB", line 79ORA-06512: 在 "SYS.DBMS_JOB", line 136ORA-06512: 在 line 5 上面兄弟何必这么惜墨 。我在pl/sql中是这样写的.declare job1 number;begin sys.dbms_job.submit( :job1, 'proc_city_date2t_city_orders', sysdate, 'trunc(sysdate + 1)');end;报错:并非所有变量都已绑定. declare job_city_day2t_city_orders number; begin sys.dbms_job.submit( job =>job_city_day2t_city_orders, what=>'proc_city_date2t_city_orders;', next_date=>to_date('14-05-2008 17:00:00','dd-mm-yyyy hh24:mi:ss'), interval => 'trunc(sysdate + 1)', no_parse => false ); sys.dbms_output.put_line('Job Number is :' ¦ ¦ to_char(job_city_day2t_city_orders)); commit; end; 红色部分,你少写了个; 带有入参和出参的存储过程的调用 数据库间用触发器同步数据,响应慢得要死。。。 在线急等``` oracle10g 远程归档问题 求教一个比较怪异的SQL查询问题的解决方案!谢谢大家了! JDBC:java.sql.SQLException: 不允许的操作: Unsupported syntax for refreshRow() -- 如何解决? 牛人来看看一个sql问题,在线等,急!!! 有没有人解决这样的远程调用? (9)菜鸟问题!!!容易拿分!! ORACLE中,如果字段名刚好是关键字,select语句该怎么写? like id+'%' 能否用到索引 数据库导入问题
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => '存储过程名'
,next_date => to_date('01/06/2008 00:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(SYSDATE)) + 1'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
/
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => '存储过程名'
,next_date => to_date('01/06/2008 00:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(SYSDATE)) + 1'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
/
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
( job => X
,what => '存储过程;'
,next_date => to_date('01/06/2008 00:00:00','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(SYSDATE) + 1'
,no_parse => FALSE
);
SYS.DBMS_OUTPUT.PUT_LINE('Job Number is: ' || to_char(x));
COMMIT;
END;
/
declare
job_city_day2t_city_orders number;
begin
sys.dbms_job.submit(
job =>job_city_day2t_city_orders,
what=>'proc_city_date2t_city_orders',
next_date=>to_date('14-05-2008 17:00:00','dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate + 1)',
no_parse => false
);
sys.dbms_output.put_line('Job Number is :' || to_char(job_city_day2t_city_orders));
commit;
end;
出现
ORA-06550: 第 1 行, 第 122 列:
PLS-00103: 出现符号 "END"在需要下列之一时:
:= . ( @ % ;
符号 ";" 被替换为 "END" 后继续。
ORA-06512: 在 "SYS.DBMS_JOB", line 79
ORA-06512: 在 "SYS.DBMS_JOB", line 136
ORA-06512: 在 line 5
job1 number;
begin
sys.dbms_job.submit(
:job1,
'proc_city_date2t_city_orders',
sysdate,
'trunc(sysdate + 1)'
);
end;报错:
并非所有变量都已绑定.
job_city_day2t_city_orders number;
begin
sys.dbms_job.submit(
job =>job_city_day2t_city_orders,
what=>'proc_city_date2t_city_orders;',
next_date=>to_date('14-05-2008 17:00:00','dd-mm-yyyy hh24:mi:ss'),
interval => 'trunc(sysdate + 1)',
no_parse => false
);
sys.dbms_output.put_line('Job Number is :' ¦ ¦ to_char(job_city_day2t_city_orders));
commit;
end; 红色部分,你少写了个;