MERGE INTO 문법
MERGE INTO
A_TABLE A
USING
B_TABLE B
ON
(
B.NO ='0' AND
A.ID =B.ID
)
WHEN MATCHED THEN
UPDATE
SET
VAL ='10000',
VAL2 =VAL2 +10
[출처] Oracle Update Join|작성자 라이오스
MERGE INTO 타켓테이블
USING 조인테이블
ON ( 타켓테이블.컬럼 = 조인테이블.컬럼 )
WHEN MATCHED THEN
UPDATE SET
..
WHEN NOT MATCHED THEN
INSERT ( 컬럼1, 컬럼2, .. )
VALUES ( VALUE1, VALUES2, .. )
MERGE INTO ULT C
USING (SELECT B.CONT, B.LAN, B.DES
FROM TENT A, MULTI_LANG B
WHERE A.KEY IS NULL
AND A.CONT = B.CONT
AND B.DES LIKE '%\n%') D
ON (C.CONT = D.CONT AND C.LAN = D.LAN)
WHEN MATCHED
THEN
UPDATE SET C.DES = REPLACE (C.DES, '\n', '')
MERGE INTO schema.table_name1 C
USING (SELECT B.ID, B.LCD, B.DTION
FROM schema.table_name2 A, schema.table_name1 B
WHERE A.ITKEY IS NULL
AND A.ID = B.ID
AND B.DTION LIKE '%\n%') D
ON (C.ID = D.ID AND C.CD = D.CD)
WHEN MATCHED
THEN
UPDATE SET C.DTION = REPLACE (C.DTION, '\n', '')