MERGE INTO yn_netcut.his_rms_bts_in_net A
USING ( SELECT A.FLOW_NO,B.ACTIVITYDEFID,B.WORKITEMNAME FROM yn_netcut.t_bpm_form_info A,yn_netcut.wfworkitem B WHERE A.PROC_INS_ID=B.PROCESSINSTID
AND A.Flow_Model='com.inspur.app.btsInNetNew.process.btsInNet')B
ON(A.Apply_Id=B.FLOW_NO AND A.STEP_ID=B.ACTIVITYDEFID)
WHEN NOT MATCHED THEN
INSERT(his_int_id, int_id, standard_name, zone_id, city_id, related_site,
equiproom_id, longitude, latitude, altitude, vendor_id, equipment_model, fre_band, trx_num,
cell_num,
village_flag, bts_sort, btscover_type, coverage_type, is_net, address, bts_no, related_bsc, cells_type,
trans_type, inuse_date, contingency_type, op_vendor, repair_vendor, softwareversion,
powershare_flag,
permanent_assets_no, portect_type, stateflag, modify_by, modify_date, create_by, create_date, apply_id,
step_id, buider, zone_name, city_name, vendor_name, related_site_name,
equiproom_name, related_bsc_name
)VALUES(SELECT seq_eomsirms_info.nextval,int_id, standard_name, zone_id, city_id, related_site,
equiproom_id, longitude, latitude, altitude, vendor_id, equipment_model, fre_band, trx_num,
cell_num,
village_flag, bts_sort, btscover_type, coverage_type, is_net, address, bts_no, related_bsc, cells_type,
trans_type, inuse_date, contingency_type, op_vendor, repair_vendor, softwareversion,
powershare_flag,
permanent_assets_no, portect_type, stateflag, modify_by, modify_date, create_by, create_date, apply_id,
B.ACTIVITYDEFID, buider, zone_name, city_name, vendor_name, related_site_name,
equiproom_name, related_bsc_name FROM yn_netcut.his_rms_bts_in_net WHERE Step_Id='optimize')
merge insert select问题
- 写回答
- 好问题 0 提建议
- 追加酬金
- 关注问题
- 邀请回答
-
1条回答 默认 最新
悬赏问题
- ¥15 装 pytorch 的时候出了好多问题,遇到这种情况怎么处理?
- ¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
- ¥15 手机接入宽带网线,如何释放宽带全部速度
- ¥30 关于#r语言#的问题:如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
- ¥15 ETLCloud 处理json多层级问题
- ¥15 matlab中使用gurobi时报错
- ¥15 这个主板怎么能扩出一两个sata口
- ¥15 不是,这到底错哪儿了😭
- ¥15 2020长安杯与连接网探
- ¥15 关于#matlab#的问题:在模糊控制器中选出线路信息,在simulink中根据线路信息生成速度时间目标曲线(初速度为20m/s,15秒后减为0的速度时间图像)我想问线路信息是什么