Merge Statement in SQL Oracle - Practical Demo of merging two contact tables

Показать описание

This video step by step explains the concept of merge statement in oracle with practical demonstrations. Here, in this example i have created two tables contact1 and contact2 then based on contact_id i have merge the record from contact2 to contact1. If the contactID is found in contact2 then i am updating the record from contact2 to contact1 and if the contactID is not found in contact2 then i am inserting the record from contact2 to contact1.

Data and Table
CREATE TABLE CONTACT1(CID NUMBER(3) PRIMARY KEY,
NAME VARCHAR2(30),
MOBILE NUMBER(10),
EMAIL VARCHAR2(30))
/
CREATE TABLE CONTACT2(CID NUMBER(3) PRIMARY KEY,
NAME VARCHAR2(30),
MOBILE NUMBER(10),
EMAIL VARCHAR2(30))
/

For Learning More about Programming