Details
-
Technical task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
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