DeclareHitoryid Number; flow_id Number; item_result_new_id Number; node_item_result_id Number; Common_diag_seqvarchar2( -); New_diag_seqvarchar2( -); K Number; Indicator_index Number;beginCommon_diag_seq:='2938564F-DDEC-4564-9E1C-FB7085B544DE'; --Historical RecordsK:=0 forIinch 1..4000000Loop K:=K+1; Historyid:=Td_diag.s_diag_history.nextval; New_diag.t_diag_history (ID, diag_sequence, diag_type, Use_scenario, Useridentity, Service_type, Special_type, Fault_symptom, Operator_account, params, start_time, End_time, Insert_time, status)
Values(Historyid, New_diag_seq,'2', 'CC', '20966666666', 'HSI', 'NULL', 'COPY_56CFC5C86D7D469CBF7D276D8A622C95_FTTH_FTTB_LAN_DSI_FBB', 'Admin', '{dimension=fbb| | hsi| | ftth,useridentity=20966666666}', Strdev2itemsmap={"Modem":[' Ftth_fttb_lan_fttb_dsi_f ']}, ServiceType=all}, Sysdate, Sysdate, Sysdate,0 ); EndLoop; Commit;End;
SQL function making data sample (i)