Merge statement allows merging data from two tables subsequently. It selects data from the source table and inserts/updates the data in the destination table as per the condition specified in the query. Merge command is useful in Data warehousing applications.
