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条回答 默认 最新
悬赏问题
- ¥50 安卓adb backup备份子用户应用数据失败
- ¥20 有人能用聚类分析帮我分析一下文本内容嘛
- ¥15 请问Lammps做复合材料拉伸模拟,应力应变曲线问题
- ¥30 python代码,帮调试
- ¥15 #MATLAB仿真#车辆换道路径规划
- ¥15 java 操作 elasticsearch 8.1 实现 索引的重建
- ¥15 数据可视化Python
- ¥15 要给毕业设计添加扫码登录的功能!!有偿
- ¥15 kafka 分区副本增加会导致消息丢失或者不可用吗?
- ¥15 微信公众号自制会员卡没有收款渠道啊