UPDATE FLTAC_PLAN_DETAIL T1
SET (
ESTIMATED_SITE_HOUR_CONTR,
ESTIMATED_CONTRIBUTE
) = (
SELECT
SUM (ESTIMATED_SITE_HOUR_CONTR) AS ESTIMATED_SITE_HOUR_CONTR,
SUM (ESTIMATED_CONTRIBUTE) AS ESTIMATED_CONTRIBUTE
FROM
FLTAC_FLIGHT_DETAIL T2
WHERE
PLAN_ID = 201
AND FLIGHT_NO = T1.FLIGHT_NO
AND SUB_AC_TYPE = T1.SUB_AC_TYPE
GROUP BY
FLIGHT_NO,
SUB_AC_TYPE
)
WHERE
T1.PLAN_ID = 201
AND EXISTS (
SELECT 1
FROM
FLTAC_FLIGHT_DETAIL T2
WHERE
T1.FLIGHT_NO = T2.FLIGHT_NO
AND T1.SUB_AC_TYPE = T2.SUB_AC_TYPE
)
Oracle下的一个插入语句
最新推荐文章于 2023-06-06 17:56:10 发布