夸用户 首先必须的有表的访问权限 其实 就是 insert into user2.c select ... from user1.a t,user1.b k where t.col=k.col 夸库必须是dblink 你先创建个链接 link insert into user2.c@link select ... from user1.a t,user1.b k where t.col=k.col
insert into user2.c@link select ... from user1.a t,user1.b k where t.col=k.col这句话应该错了吧,user2是目标对象,user1才是源,是不是改反过来insert into user2.c as select ... from user1.a@link t ,user1.b@link k where t.col=k.col 不过这样是错的! 会报缺少关键字values,有点奇怪!
已经自己搞定了纠正你一个错误点: insert into user2.c as select ... from user1.a@link t ,user1.b@link k where t.col=k.col这个as是不需要的
select A.字段1,A.....M,B.字段1,B.....
from user1.A A,user1.B B
where 条件
首先必须的有表的访问权限 其实 就是
insert into user2.c select ... from user1.a t,user1.b k where t.col=k.col
夸库必须是dblink 你先创建个链接 link
insert into user2.c@link select ... from user1.a t,user1.b k where t.col=k.col
insert into user2.c@link select ... from user1.a t,user1.b k where t.col=k.col这句话应该错了吧,user2是目标对象,user1才是源,是不是改反过来insert into user2.c as select ... from user1.a@link t ,user1.b@link k where t.col=k.col
不过这样是错的! 会报缺少关键字values,有点奇怪!
已经自己搞定了纠正你一个错误点:
insert into user2.c as select ... from user1.a@link t ,user1.b@link k
where t.col=k.col这个as是不需要的