Details
-
Type:
Technical task
-
Status: Open (View Workflow)
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: None
-
Component/s: None
-
Labels:
Description
Merge statement is a special statement, it works something like "REPLACE INTO", "INSERT INTO ON DUPLICATE KEY UPDATE" but provides more flexibility in terms of what can be done.
It can INSERT, UPDATE and / or DELETE data using the same statement depending on the criteria.
Oracle Link: https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9016.htm#SQLRF01606