在本地执行下面语句是报回滚小了
insert into test
SELECT trunc(sysdate - 1),TA.com_code,tb.name,ta.mc,
TB.PP,TB.dzxl,ta.gz,TA.gys,TA.jyfs,
TA.zhhsjj,TA.zhbhsjj,round(TA.kl,4),
TB.lsj,TA.kcsl1,TA.kcbhsje1,TA.kchsje1,
ta.kcsl1*tb.lsj
FROM test@db_db TA,test1@dba_db TB
WHERE TA.splb<>'8' AND TA.com_code=TB.code and ta.kcsl1<>0 ;
commit;
insert into test
SELECT trunc(sysdate - 1),TA.com_code,tb.name,ta.mc,
TB.PP,TB.dzxl,ta.gz,TA.gys,TA.jyfs,
TA.zhhsjj,TA.zhbhsjj,round(TA.kl,4),
TB.lsj,TA.kcsl1,TA.kcbhsje1,TA.kchsje1,
ta.kcsl1*tb.lsj
FROM test@db_db TA,test1@dba_db TB
WHERE TA.splb<>'8' AND TA.com_code=TB.code and ta.kcsl1<>0 ;
commit;
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货