INSERT INTO ACCESSSTATISTIC(DestHost,AccessCount,StatisticDate)
select * from (select DestHost ,sum(AccessCount) ,sysdate from "ACCESS_TB_2005_06_29" GROUP BY DestHost )
where rownum<=50;ACCESS_TB_2005_06_29 这是不是视图
如果是视图,ACCESSSTATISTIC表是为空
select * from (select DestHost ,sum(AccessCount) ,sysdate from "ACCESS_TB_2005_06_29" GROUP BY DestHost )
where rownum<=50;ACCESS_TB_2005_06_29 这是不是视图
如果是视图,ACCESSSTATISTIC表是为空
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货