Q
In a MERGE statement, which clause handles rows that already exist?
-
A
WHEN FOUND THEN INSERT
-
B
ON DUPLICATE KEY UPDATE
-
C
WHEN MATCHED THEN UPDATE
-
D
IF EXISTS THEN UPDATE
Correct Answer:
C. WHEN MATCHED THEN UPDATE
Explanation:
ON DUPLICATE KEY UPDATE is MySQL. Oracle uses WHEN MATCHED / WHEN NOT MATCHED.
