Oracle实现将查询结果进行修改后再批量插入数据库
table_name为你需要查询的表名以及插入的表名
INSERT
INTO
table_name(
SELECT
TUNNEL_ID,
IS_USED,
CASE
WHEN CITY = '3604' THEN '3611'
ELSE NULL
END CITY,
IS_BAN
FROM
table_name
WHERE
CITY = '3604')
Oracle实现将查询结果进行修改后再批量插入数据库
table_name为你需要查询的表名以及插入的表名
INSERT
INTO
table_name(
SELECT
TUNNEL_ID,
IS_USED,
CASE
WHEN CITY = '3604' THEN '3611'
ELSE NULL
END CITY,
IS_BAN
FROM
table_name
WHERE
CITY = '3604')