SQL函数造数据样例（一）
时间：2021-07-01 10:21:17
帮助过：54人阅读
hitoryid number;
flow_id number;
item_result_new_id number;
node_item_result_id number;
common_diag_seq varchar2(
64);
new_diag_seq varchar2(
64);
k number;
indicator_index number;
begin
common_diag_seq:=‘2938564f-ddec-4564-9e1c-fb7085b544de‘;
--历史记录
k:
=0
for i
in 1 ..
4000000 loop
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
);
end loop;
commit;
end;
SQL函数造数据样例（一）
标签：use indicator mit char sys art special his opera
