MERGE INTO bm_bc_block_main_info T
USING (
SELECT p_PROJECT_NO AS PROJECT_NO,
p_BLOCK_NO AS block_no FROM dual
) S
ON (T.PROJECT_NO = S.PROJECT_NO
AND t.block_no = s.block_no)
WHEN MATCHED THEN
UPDATE SET T.SHOP_ID = p_SHOP_ID
WHEN NOT MATCHED THEN
INSERT (T.PROJECT_NO, T.BLOCK_NO, T.SHOP_ID, T.CREATE_DATE, T.CREATE_USER, T.MODIFY_DATE, T.MODIFY_USER, T.IS_COMPLATE)
VALUES (p_PROJECT_NO, p_BLOCK_NO, p_SHOP_ID, p_CREATE_DATE, p_CREATE_USER, p_MODIFY_DATE, p_MODIFY_USER, p_IS_COMPLETE)
;
여기서 주의할 점은 INSERT에서 위에서 처럼 T 테이블 기준으로 가야함.
조회 값이 없을땐 위 SELECT에서 처럼 DUAL에서라도 SELECT!!!
