oracle定時器，調用預存程序，定時從n張表中取值新增到本地一張表中

標籤：

--建立新增本機資料庫的預存程序create or replaceprocedure pro_electric_record as  begin    insert into electric_meter_record(id,basestation_id,name,meter_number,createtime)    select sys_guid(),substr(s.sname,0,36),s.sname,s.svalue,sysdate from rtdbvs s where s.sname like ‘%POWER_DQDL%‘;    commit;  end;--拼接另一張表中的值select sys_guid(),substr(s.sname,0,36),s.sname,s.svalue,sysdate from rtdbvs s where s.sname like ‘%POWER_DQDL%‘;--查看預存程序select * from user_source where type=‘PROCEDURE‘--刪除預存程序drop procedure pro_electric_record--dbms_scheduler建立job調度--查詢select * from dba_scheduler_jobs;--建立jobbegin  dbms_scheduler.create_job(  job_name=>‘electric_meter_record_insert‘,  job_type=>‘STORED_PROCEDURE‘,  job_action=>‘pro_electric_record‘,  start_date=>sysdate,  repeat_interval=>‘FREQ=DAILY;BYHOUR=0;BYMINUTE=00;BYSECOND=0‘,  comments=>‘電錶錄入表‘,  auto_drop=>false  );end;--重點（查詢N張表中的資料存放區到本地一張表中）insert into electric_meter_record(id,basestation_id,name,meter_number,createtime)    select sys_guid(),substr(s.sname,0,36),s.sname,s.svalue,sysdate from rtdbvs s where s.sname like ‘%POWER_DQDL%‘;

 ：

oracle定時器，調用預存程序，定時從n張表中取值新增到本地一張表中