DB/Oracle
MERGE INTO
냐옴
2013. 5. 30. 16:00
MERGE INTO ATEST
USING DUAL
ON (SEQ = 12)
WHEN MATCHED THEN
UPDATE SET
TITLE = 'UPDATE'
WHEN NOT MATCHED THEN
INSERT (SEQ, TITLE)
VALUES (12, 'INSERT')