반응형 다량의 건 일괄 저장1 [Query] Merge Into(다량의 건 일괄로) MERGE INTO TB_ATTB T USING( SELECT A.REQ_NO , B.TEST_RST , 'Y' USE_YN , '0' INST_ID , SYSDATE INST_DS , '0' UPDT_ID , SYSDATE UPDT_DS FROM TB_MST A , TB_DTL B WHERE 1=1 AND A.REQ_NO = B.REQ_NO AND B.ITEM_CD IN ('S0B70', 'S0B710') AND A.REQ_DT BETWEEN '20130726' AND '20130825' ) S ON (S.REQ_NO = T.REQ_NO AND S.ATTB_ID = T.ATTB_ID) WHEN MATCHED THEN UPDATE SET T.ATTB_VAL = S.TEST_RST , T.USE_YN = .. 2015. 7. 31. 이전 1 다음 반응형