用这种方式可以插入三条数据到本库的表
insert into aa_temp6(oid,TRANSFORMER_ID,just_power)
(
select PW_ATTEMPER_PI_BYQ_CUS_seq.nextval@PWSCT,
--gg_pd_zfbyq_lb_seq.nextval+9900000 AA,
a.g3e_fid,
1 yx_fid
--,A.CD_SSXL
from B$COMMON_N a, traceresult b,aa_temp7 C--,dual@pwsct
where a.g3e_fid = b.g3e_fid
and b.g3e_tno = 135631
and b.g3e_fno = 148
AND C.KXMC=trim(replace(replace(A.CD_SSXL,chr(10)),chr(13)))
AND A.LTT_ID=0
) 但将目标表aa_temp6 改为远程数据库的表PW_ATTEMPER_PI_BYQ_CUS@PWSCT,就不能插入到远程数据库 insert into PW_ATTEMPER_PI_BYQ_CUS@PWSCT(oid,TRANSFORMER_ID,just_power) (
select PW_ATTEMPER_PI_BYQ_CUS_seq.nextval@PWSCT,
--gg_pd_zfbyq_lb_seq.nextval+9900000 AA,
a.g3e_fid,
1 yx_fid
--,A.CD_SSXL
from B$COMMON_N a, traceresult b,aa_temp7 C--,dual@pwsct
where a.g3e_fid = b.g3e_fid
and b.g3e_tno = 135631
and b.g3e_fno = 148
AND C.KXMC=trim(replace(replace(A.CD_SSXL,chr(10)),chr(13)))
AND A.LTT_ID=0
) 不过用如下语句可以正常插入,只是将B$COMMON_N提取需要的一部分到aa_temp8,表结构完全一致,只是数据少了一些 insert into PW_ATTEMPER_PI_BYQ_CUS@PWSCT(oid,TRANSFORMER_ID,just_power) (
select PW_ATTEMPER_PI_BYQ_CUS_seq.nextval@PWSCT,
--gg_pd_zfbyq_lb_seq.nextval+9900000 AA,
a.g3e_fid,
1 yx_fid
--,A.CD_SSXL
from aa_temp8, traceresult b,aa_temp7 C--,dual@pwsct
where a.g3e_fid = b.g3e_fid
and b.g3e_tno = 135631
and b.g3e_fno = 148
AND C.KXMC=trim(replace(replace(A.CD_SSXL,chr(10)),chr(13)))
AND A.LTT_ID=0
)
请高手们帮帮忙
insert into aa_temp6(oid,TRANSFORMER_ID,just_power)
(
select PW_ATTEMPER_PI_BYQ_CUS_seq.nextval@PWSCT,
--gg_pd_zfbyq_lb_seq.nextval+9900000 AA,
a.g3e_fid,
1 yx_fid
--,A.CD_SSXL
from B$COMMON_N a, traceresult b,aa_temp7 C--,dual@pwsct
where a.g3e_fid = b.g3e_fid
and b.g3e_tno = 135631
and b.g3e_fno = 148
AND C.KXMC=trim(replace(replace(A.CD_SSXL,chr(10)),chr(13)))
AND A.LTT_ID=0
) 但将目标表aa_temp6 改为远程数据库的表PW_ATTEMPER_PI_BYQ_CUS@PWSCT,就不能插入到远程数据库 insert into PW_ATTEMPER_PI_BYQ_CUS@PWSCT(oid,TRANSFORMER_ID,just_power) (
select PW_ATTEMPER_PI_BYQ_CUS_seq.nextval@PWSCT,
--gg_pd_zfbyq_lb_seq.nextval+9900000 AA,
a.g3e_fid,
1 yx_fid
--,A.CD_SSXL
from B$COMMON_N a, traceresult b,aa_temp7 C--,dual@pwsct
where a.g3e_fid = b.g3e_fid
and b.g3e_tno = 135631
and b.g3e_fno = 148
AND C.KXMC=trim(replace(replace(A.CD_SSXL,chr(10)),chr(13)))
AND A.LTT_ID=0
) 不过用如下语句可以正常插入,只是将B$COMMON_N提取需要的一部分到aa_temp8,表结构完全一致,只是数据少了一些 insert into PW_ATTEMPER_PI_BYQ_CUS@PWSCT(oid,TRANSFORMER_ID,just_power) (
select PW_ATTEMPER_PI_BYQ_CUS_seq.nextval@PWSCT,
--gg_pd_zfbyq_lb_seq.nextval+9900000 AA,
a.g3e_fid,
1 yx_fid
--,A.CD_SSXL
from aa_temp8, traceresult b,aa_temp7 C--,dual@pwsct
where a.g3e_fid = b.g3e_fid
and b.g3e_tno = 135631
and b.g3e_fno = 148
AND C.KXMC=trim(replace(replace(A.CD_SSXL,chr(10)),chr(13)))
AND A.LTT_ID=0
)
请高手们帮帮忙
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货