Merge Syntax

  1. A. MERGE INTO <> USING <> WHEN MATCHED THEN UPDATE ------ WHEN NOT MATCHED THEN INSERT -------

  2. B. MERGE <> USING <> WHEN MATCHED THEN UPDATE ------ WHEN NOT MATCHED THEN INSERT -------

  3. C. MERGE INTO <> USING <> WHEN EXISTS THEN UPDATE ------

  4. D. MERGE INTO <> USING <> WHEN NOT MATCHED THEN INSERT ------

  5. Both A and D


Correct Option: A

Find more quizzes: