oracle将A表的记录插入到B表中

你把B表有但A表没有的字段约束都设置为允许NULL，之后用merge merge into Busing Aon (A.列名=B.列名)when matched thenupdate set B.列名2=A.列名2,B.列名3=A.列名3when not matched theninsert values(A.列名,A.列名2,A.列名3)