2020-07-16

MERGEINTOtable_name alias1 USING(table|view|sub_query)alias2 ON(joincondition)WHENMATCHEDTHENUPDATEtable_nameSETcol1=col_val1WHENNOTMATCHEDTHENINSERT(column_list)VALUES(column_values);模仿mergeintoAccountt1using(select'3'AccountID,'肖文博'AccountNamefromdual)t2 on(t1.AccountID=t2.AccountID)when matched then updatesett1.AccountName=t2.AccountNamewhen not matched then insert values(t2.AccountID,t2.AccountName);commit;