DECLARE CURSOR MYCUR IS SELECT B.AREANAME ,A.CHANNELNAME,A.BCCS,A.BCMS,A.PXID,B.BCZCS,B.BCZMC,B.ZPXID
FROM JB_TVFB2 A,JB_TVFB2Z B WHERE SUBSTR(A.CHANNELNO,1,2)=B.AREANO
ORDER BY BCZMC,BCMS DESC;
VAREANAME VARCHAR2(150);
VCHANNELNAME VARCHAR2(150);
VBCCS NUMBER;
VBCMS NUMBER;
VPXID NUMBER;
VBCZCS NUMBER;
VBCZMC NUMBER;
VZPXID NUMBER;
BEGIN
OPEN MYCUR;
LOOP
FETCH MYCUR INTO VAREANAME,VCHANNELNAME,VBCCS,VBCMS,VPXID,VBCZCS,VBCZMC,VZPXID;
EXIT WHEN MYCUR%NOTFOUND;
END LOOP;
END;
CLOSE MYCUR;
FROM JB_TVFB2 A,JB_TVFB2Z B WHERE SUBSTR(A.CHANNELNO,1,2)=B.AREANO
ORDER BY BCZMC,BCMS DESC;
VAREANAME VARCHAR2(150);
VCHANNELNAME VARCHAR2(150);
VBCCS NUMBER;
VBCMS NUMBER;
VPXID NUMBER;
VBCZCS NUMBER;
VBCZMC NUMBER;
VZPXID NUMBER;
BEGIN
OPEN MYCUR;
LOOP
FETCH MYCUR INTO VAREANAME,VCHANNELNAME,VBCCS,VBCMS,VPXID,VBCZCS,VBCZMC,VZPXID;
EXIT WHEN MYCUR%NOTFOUND;
END LOOP;
END;
CLOSE MYCUR;
FROM JB_TVFB2 A,JB_TVFB2Z B WHERE SUBSTR(A.CHANNELNO,1,2)=B.AREANO
ORDER BY BCZMC,BCMS DESC;
VAREANAME VARCHAR2(150);
VCHANNELNAME VARCHAR2(150);
VBCCS NUMBER;
VBCMS NUMBER;
VPXID NUMBER;
VBCZCS NUMBER;
VBCZMC NUMBER;
VZPXID NUMBER;
BEGIN
OPEN MYCUR;
LOOP
FETCH MYCUR INTO VAREANAME,VCHANNELNAME,VBCCS,VBCMS,VPXID,VBCZCS,VBCZMC,VZPXID;
EXIT WHEN MYCUR%NOTFOUND;
END LOOP;
CLOSE MYCUR; --提前!
END;
--查看一下这个有没有数据!
SELECT B.AREANAME ,A.CHANNELNAME,A.BCCS,A.BCMS,A.PXID,B.BCZCS,B.BCZMC,B.ZPXID
FROM JB_TVFB2 A,JB_TVFB2Z B WHERE SUBSTR(A.CHANNELNO,1,2)=B.AREANO
ORDER BY BCZMC,BCMS DESC;
FROM JB_TVFB2 A,JB_TVFB2Z B WHERE SUBSTR(A.CHANNELNO,1,2)=B.AREANO
ORDER BY BCZMC,BCMS DESC;
VAREANAME VARCHAR2(150);
VCHANNELNAME VARCHAR2(150);
VBCCS NUMBER;
VBCMS NUMBER;
VPXID NUMBER;
VBCZCS NUMBER;
VBCZMC NUMBER;
VZPXID NUMBER;
BEGIN
OPEN MYCUR;
LOOP
FETCH MYCUR INTO VAREANAME,VCHANNELNAME,VBCCS,VBCMS,VPXID,VBCZCS,VBCZMC,VZPXID;
EXIT WHEN MYCUR%NOTFOUND;
dbms_output.putline(VAREANAME);--在命令窗口打印输出,记得现在打命令
set serveroutput on;
然后看看有没有数据输出
END LOOP;
CLOSE MYCUR;
END;