注意,不能有换行符,可以都是删除,也可以都是新增,也可以都是修改,也可以混着来,但是要注意业务逻辑
begin update Tablename set l1 = 1 where b1 = '1'; update Tablename set l1 = 2 where b1 = '2'; end;多条sql新增
String sqlAdd="insert all ";
for (int i = 0; i < args.length; i++) {
sqlAdd+=" into tablename(l1,l2)values(" + czlx + "," + args[i] + ")";
}
sqlAdd+=" SELECT 1 FROM DUAL";



