DECLARE
V_SQL LONG;
BEGIN FOR V_CUR IN (SELECT DISTINCT PROV_ID FROM DIM_PROV) LOOP
V_SQL := 'SELECT /*+ parallel(T,8)*/PROV_ID , SUBS_INSTANCE_ID, DEVICE_NUMBER, TOTAL_FEE_ALL
FROM ZB_DWA.DWA_V_M_CUS_MB_USER_EXT_'|| V_CUR.PROV_ID ||'@CUJFBD t
WHERE t.MONTH_ID =''201207''
AND t.service_type =''20AAAAAA''
AND t.total_fee_all <0
AND ROWNUM<6 ';
--dbms_output.put_line(v_sql);
EXECUTE IMMEDIATE V_SQL; END LOOP;
COMMIT;
END;
这个语句执行完毕之后 结果为什么看不到呢 热心的几位大神帮忙解决
V_SQL LONG;
BEGIN FOR V_CUR IN (SELECT DISTINCT PROV_ID FROM DIM_PROV) LOOP
V_SQL := 'SELECT /*+ parallel(T,8)*/PROV_ID , SUBS_INSTANCE_ID, DEVICE_NUMBER, TOTAL_FEE_ALL
FROM ZB_DWA.DWA_V_M_CUS_MB_USER_EXT_'|| V_CUR.PROV_ID ||'@CUJFBD t
WHERE t.MONTH_ID =''201207''
AND t.service_type =''20AAAAAA''
AND t.total_fee_all <0
AND ROWNUM<6 ';
--dbms_output.put_line(v_sql);
EXECUTE IMMEDIATE V_SQL; END LOOP;
COMMIT;
END;
这个语句执行完毕之后 结果为什么看不到呢 热心的几位大神帮忙解决
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货