Create or Replace Procedure Pro_Signal_Flux IsstrcurrentTime Character (25); B character (25); E character (25); begin
StrcurrentTime: = TO_CHAR (Sysdate, 'MM-DD-YYYY'); - Get Current Time for i I in 0..23 loop B: = StrcurrentTime ':' TO_CHAR (i) '0: 0'; E: = strCurrentTime ':' to_char (i) '59:59'; DECLARE currID character (14); currFlux Number; cURSOR c1 IS - defining a cursor SELECT t_loop_id, count (flux) count_flux FROM t_realtime_signal_flux_temp where time between TO_DATE (B , 'YYYY / MM / DD HH24: MI: SS') And to_date (e, 'YYYY / MM / DD HH24: MI: SS') Group by t_loop_id; EMP_REC C1% RowType; - Defining this cursor Begin for emp_rec iN c1 LOOP - read all the records in this set Currid cursor: = emp_rec.t_loop_id; currFlux: = emp_rec.count_flux; INSERT INTO T_ANALYSE_LOOP VALUES (FUN_GETID, currID, TO_DATE (B, 'YYYY / MM / DD HH24 : MI: SS '), CURRFLUX,' 2 '; end loop; end; end loop;
End pro_signal_flux;
