- MERGE INTO CS_PERFORMANCE_CURRENT A
- USING (SELECT D.SEQ_ID
- FROM CS_TARGET_MODEL_REL D,
- CS_AREA M
- WHERE D.ASSESS_ID = 1265 AND
- D.STAFF_ID = 8 AND
- D.TARGET_MODEL_ID = 332 AND
- D.STATE = TO_CHAR(2) AND
- D.AREA_ID = M.AREA_ID AND
- M.AREA_NAME = '永兴支局') H
- ON (A.TARGET_MODE_SEQ_ID = H.SEQ_ID)
- WHEN MATCHED THEN
- UPDATE SET A.PERFORMANCE_SCORE = '0.00', A.ASSESS_DESC = '劳动纪律考核' WHERE A.COM_DATE = TO_DATE('20110801', 'YYYYMMDD');
利用Merge代替复杂的UPDATE语句
最新推荐文章于 2024-07-05 14:14:21 发布