UPDATE EVC_OS_CHARGE_T T1
SET CHARGE_NUM = (
SELECT
T2.CHARGE_CODE
FROM
EVC_OS_CHARGE_T T2
WHERE
T1.CHARGE_ID = T2.CHARGE_ID
);
oracle 同一表中的某个字段内容更新成另一个字段内容
最新推荐文章于 2024-08-12 21:29:36 发布
UPDATE EVC_OS_CHARGE_T T1
SET CHARGE_NUM = (
SELECT
T2.CHARGE_CODE
FROM
EVC_OS_CHARGE_T T2
WHERE
T1.CHARGE_ID = T2.CHARGE_ID
);