MERGE usage

xiaoxiao2021-04-08  331

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

转载请注明原文地址:https://www.9cbs.com/read-132847.html

New Post(0)