[ORACLE] MERGE INTO INSERT AND UPDATE Method of use

ORACLE MERGE INTO  Method of use

*merge into method, it is available starting with Oracle9

<Grammer, How to use>

MERGER INTO TABLE_NAME A

USING TABLE_NAME/VIEW/SELECT statement

ON (JOIN Condition)

WHEN MATCHED THEN

UPDATE SET

Column1 = VALUE1

Column2 = VALUE2

...

WHEN NOT MATHCED THEN

INSERT (Column1, Column2, ...)

VALUES (Value1, Value2, ...);

<Query creation example>

MERGE INTO TEST1 A

USING (SELECT SEQ FROM TEST2) B

ON (A.SEQ = B.SEQ)

WHEN MATCHED THEN

UPDATE SET

A.COL1 = 1

A.COL2 = A.COL2+1

WHEN NOT MATHCED THEN

INSERT (SEQ, COL1, COL2)

VALUES(1, 2, 3);

So if merge table with select table is the same, In USING put DUAL

Reference site : http://blog.naver.com/geeyoming/220239802214