用户表的DEPT_ID字段信息有误,从部门表取最新DEPT_ID更新。示例如下:
--通过DEPT_NAME字段关联两表,更新TABLE_USER表的DEPT_ID字段
UPDATE TABLE_USER U
SET U.DEPT_ID =
(SELECT D.DEPT_ID
FROM TABLE_DEPT D
WHERE U.DEPT_NAME = D.DEPT_NAME
AND ROWNUM = 1)
WHERE EXISTS (SELECT 1 FROM TABLE_DEPT D WHERE U.DEPT_NAME = D.DEPT_NAME);