根据已知查询插入到某表的sql写法

最新推荐文章于 2025-08-07 10:09:23 发布

原创最新推荐文章于 2025-08-07 10:09:23 发布 · 229 阅读

0 ·

CC 4.0 BY-SA版权

ORACLE 专栏收录该内容

13 篇文章

订阅专栏

本文详细介绍了一种针对CRM系统中客户数据的批量更新方法，通过使用SQL语句结合序列生成器，实现了对特定部门ID的数据进行高效更新，同时展示了如何在更新过程中保持数据的一致性和准确性。

INSERT INTO BO_CRM_CLIENT_SERDPT
(ID,
ORGNO,
BINDID,
CREATEDATE,
CREATEUSER,
UPDATEDATE,
UPDATEUSER,
WORKFLOWID,
WORKFLOWSTEPID,
ISEND,
GSID,
GSDM,
GSMC,
BMID,
BMMC,
KHBMMC,
DKHZJZH,
DKHZJXM,
SSGSDM,
SSGSMC,
KHBMBH,
KHJLZH,
KHJLXM,
KHBH)
SELECT BO_CRM_CLIENT_SERDPT_SEQ.NEXTVAL,
ORGNO,
BINDID,
CREATEDATE,
CREATEUSER,
UPDATEDATE,
UPDATEUSER,
WORKFLOWID,
WORKFLOWSTEPID,
ISEND,
GSID,
GSDM,
GSMC,
BMID,
(SELECT DEPARTMENTNAME FROM ORGDEPARTMENT WHERE ID = BMID) BMMC,
KHBMMC,
DKHZJZH,
DKHZJXM,
SSGSDM,
SSGSMC,
KHBMBH,
KHJLZH,
KHJLXM,
KHBH
FROM (SELECT ORGNO,
BINDID,
SYSDATE CREATEDATE,
'admin' CREATEUSER,
SYSDATE UPDATEDATE,
'admin' UPDATEUSER,
WORKFLOWID,
WORKFLOWSTEPID,
ISEND,
GSID,
GSDM,
GSMC,
(CASE BMID
WHEN CAST('7880' AS NVARCHAR2(100)) THEN
CAST('51876' AS NVARCHAR2(100))
WHEN CAST('7882' AS NVARCHAR2(100)) THEN
CAST('51889' AS NVARCHAR2(100))
WHEN CAST('7879' AS NVARCHAR2(100)) THEN
CAST('51893' AS NVARCHAR2(100))
WHEN CAST('7881' AS NVARCHAR2(100)) THEN
CAST('51903' AS NVARCHAR2(100))
WHEN CAST('45807' AS NVARCHAR2(100)) THEN
CAST('51907' AS NVARCHAR2(100))
WHEN CAST('32809' AS NVARCHAR2(100)) THEN
CAST('51937' AS NVARCHAR2(100))
WHEN CAST('46837' AS NVARCHAR2(100)) THEN
CAST('51942' AS NVARCHAR2(100))
WHEN CAST('45790' AS NVARCHAR2(100)) THEN
CAST('51950' AS NVARCHAR2(100))
WHEN CAST('45762' AS NVARCHAR2(100)) THEN
CAST('51963' AS NVARCHAR2(100))
WHEN CAST('45764' AS NVARCHAR2(100)) THEN
CAST('51970' AS NVARCHAR2(100))
WHEN CAST('45760' AS NVARCHAR2(100)) THEN
CAST('51979' AS NVARCHAR2(100))
WHEN CAST('45768' AS NVARCHAR2(100)) THEN
CAST('51995' AS NVARCHAR2(100))
WHEN CAST('45784' AS NVARCHAR2(100)) THEN
CAST('52002' AS NVARCHAR2(100))
WHEN CAST('45786' AS NVARCHAR2(100)) THEN
CAST('52014' AS NVARCHAR2(100))
WHEN CAST('45782' AS NVARCHAR2(100)) THEN
CAST('52022' AS NVARCHAR2(100))
WHEN CAST('7896' AS NVARCHAR2(100)) THEN
CAST('52004' AS NVARCHAR2(100))
WHEN CAST('7895' AS NVARCHAR2(100)) THEN
CAST('52016' AS NVARCHAR2(100))
WHEN CAST('45772' AS NVARCHAR2(100)) THEN
CAST('51904' AS NVARCHAR2(100))
WHEN CAST('45774' AS NVARCHAR2(100)) THEN
CAST('51911' AS NVARCHAR2(100))
WHEN CAST('45776' AS NVARCHAR2(100)) THEN
CAST('51917' AS NVARCHAR2(100))
WHEN CAST('45778' AS NVARCHAR2(100)) THEN
CAST('51921' AS NVARCHAR2(100))
WHEN CAST('45770' AS NVARCHAR2(100)) THEN
CAST('51931' AS NVARCHAR2(100))
WHEN CAST('45788' AS NVARCHAR2(100)) THEN
CAST('51936' AS NVARCHAR2(100))
WHEN CAST('7911' AS NVARCHAR2(100)) THEN
CAST('51877' AS NVARCHAR2(100))
WHEN CAST('32811' AS NVARCHAR2(100)) THEN
CAST('51879' AS NVARCHAR2(100))
WHEN CAST('32810' AS NVARCHAR2(100)) THEN
CAST('51880' AS NVARCHAR2(100))
WHEN CAST('45780' AS NVARCHAR2(100)) THEN
CAST('51882' AS NVARCHAR2(100))
WHEN CAST('46601' AS NVARCHAR2(100)) THEN
CAST('52032' AS NVARCHAR2(100))
END) BMID,
KHBMMC,
DKHZJZH,
DKHZJXM,
SSGSDM,
SSGSMC,
KHBMBH,
KHJLZH,
KHJLXM,
KHBH
FROM BO_CRM_CLIENT_SERDPT
WHERE BMID IN (7880,
7882,
7879,
7881,
45807,
32809,
46837,
45790,
45762,
45764,
45760,
45768,
45784,
45786,
45782,
7896,
7895,
45772,
45774,
45776,
45778,
45770,
45788,
7911,
32811,
32810,
45780,
46601));