如下SQL,大表500列,请问有没有什么办法能够一次插入或者更新整行数据。
T1和T2结构完全一样。c1是主键。
MERGE INTO T T1
USING (SELECT * FROM T3, T4, T5 ... where ...) T2
ON ( T1.c1=T2.c1)
WHEN MATCHED THEN
UPDATE SET T1.c1 = T2.c1,
T1,c2 = T2.c2,
... //此处省略500行
T1.c500 = T2.c500
WHEN NOT MATCHED THEN
INSERT (c1, c2, ... c500) VALUES(T2.c1,T2.c2 ... T2.c500);