Oracle的merge into实现MySQL的replace
2022-03-21 本文已影响0人
Quick_5413
MERGE INTO schema. table alias
USING { schema. table | views | query} alias
ON {(condition) }
WHEN MATCHED THEN
UPDATE SET {clause}
WHEN NOT MATCHED THEN
INSERT VALUES {clause};
