Data management activities involve insert, update and
delete operations (
). With the MERGE feature, data insert, update and
delete operations can be done with a merge statement.
The example shown here does an insert and an update.
This feature is very commonly used in
processes and in
loads to achieve optimum load performance.