oracle中的关联更新语句示例

分类: 文章 • 2024-04-27 10:21:06

UPDATE FACT_HR_STAFF_SALARY_ARCH
SET ORG_NAME = (
   SELECT
       SHORTNAME
   FROM
       DIM_ORG
   INNER JOIN FACT_HR_STAFF_SALARY_ARCH ON (
       DIM_ORG.PK_ORG = FACT_HR_STAFF_SALARY_ARCH.PK_ORG
   )
   WHERE
       FACT_HR_STAFF_SALARY_ARCH.PK_ORG = DIM_ORG.PK_ORG
)

————————————————————————————————