--Creating a stored procedure for adding a local database Create or replaceprocedure Pro_electric_record as begin insert into Electric_meter_record (Id,basestati On_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;--stitching the values in another table select Sys_guid (), substr (s.sname,0,36), s.sname,s.svalue,sysdate from Rtdbvs s where s.sname like '% power_dqdl% ';--View stored procedure select * from User_source where type= ' PROCEDURE '--Delete stored procedure drop PROCEDURE Pro_electric_record--dbms _scheduler Create job Schedule--Query SELECT * FROM dba_scheduler_jobs;--create 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=> ' meter entry form ', auto_drop=>false); end;--focus (query n tables for data stored in a local table) 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 timers, call stored procedures, and periodically add values from n tables to a local table