반응형
MERGE INTO Tab
USING DUAL
ON (Tab.id = 'ID1')
WHEN MATCHED THEN
UPDATE SET
kr_name = '민',
...
WHEN NOT MATCHED THEN
INSERT (ID, Kr_name, ... )
VALUES (... );
반응형
MERGE INTO Tab
USING DUAL
ON (Tab.id = 'ID1')
WHEN MATCHED THEN
UPDATE SET
kr_name = '민',
...
WHEN NOT MATCHED THEN
INSERT (ID, Kr_name, ... )
VALUES (... );