Hi,

I am working on Merge statement. I know Merge is used to update/insert/delete the data. In my program,for new record do insert and existing record,do nothing.But when using merge statement 'ON' clause we are checking the data with the source table and target table.My table doesn't have unique values so I need to check every column and insert new record if any of the column is not matched. So Question is do I need to check every column or is there anyway we can check whole row data?

Thanks,
Sravani

SQL> merge into emp e
  2  using ( select * from scott.emp ) m
  3  on (   decode(m.empno,e.empno,1,0) = 1
  4    and decode(m.ename,e.ename,1,0) = 1
  5    and decode(m.deptno,e.deptno,1,0) = 1
  6    )
  7  when matched then
  8  update set sal = m.sal;

14 rows merged.