MERGE grammar:
Merge INTO TABLE_NAME USING (JOIN CONDITION) WHEN matched kil1
-------------------------------------------------- ------------------------------ MERGE PROBLEM
merge into table2 using table1 (table2.colname1 = table1.colname1) on when matched then update set table2.colname2 = table1.colname1 || ',' || table1.colname2 when not matched then insert (colname1, colname2) value (table1 .colname1.table1.colname2); merged data, don't forget Commit