How To Perform Insert update and delete changes from source and destination using Merge statement



How To Perform Insert update and delete changes from source and destination using Merge statement

How To Perform Insert update and delete changes from source and destination using Merge statement

Merge Statement syntax:
=====================
Merge Target_table_name
using source_table_name
on

When Matched Then
UPDATE

When Not Matched Then
INSERT

When Not Matched by source then
Delete;
=====================

Download Merge statement used in Video:
=============
https://www.mediafire.com/file/fz0cty2nk8tq2cg/Merge+stastement.txt/file
============