MERGE INTO table_name A
USING (table|view|query_sql) B
ON (A.col = B.col)
WHEN MATCHED THEN
UPDATE SET A.col1 = B.col_val1
WHEN NOT MATCHED THEN
INSERT (A.column_list) VALUES (column_values)
/*判断A表和B表是否满足 ON中的条件,如果满足则执行更新操作【用B表中的数据更新A表的数据】,否则在A表中插入数据 */