Database/query
ORACLE MERGE INTO
다크곰
2013. 8. 27. 13:08
MERGE INTO TK2_PROD_TEST X
USING ( SELECT PROD_ID
, ADMIT_STT
FROM TK2_PROD_20130630
WHERE UPD_DT < TO_DATE('20080101','YYYYMMDD')
AND ADMIT_STT = '1'
) A
ON (A.PROD_ID = X.PROD_ID)
WHEN MATCHED THEN
UPDATE SET X.ADMIT_STT = A.ADMIT_STT