17,377
社区成员
发帖
与我相关
我的任务
分享
DECLARE
CURSOR CUR_FOO IS SELECT LEVEL L FROM DUAL CONNECT BY LEVEL<=10;
REC_FOO CUR_FOO%ROWTYPE;
BEGIN
OPEN CUR_FOO;
LOOP
FETCH CUR_FOO INTO REC_FOO;
EXIT WHEN CUR_FOO%NOTFOUND;
IF REC_FOO.L=9 THEN
CONTINUE;
END IF;
DBMS_OUTPUT.PUT_LINE('==>'||REC_FOO.L);
END LOOP;
CLOSE CUR_FOO;
END;
==>1
==>2
==>3
==>4
==>5
==>6
==>7
==>8
==>10
DECLARE
CURSOR CUR_FOO IS SELECT LEVEL L FROM DUAL CONNECT BY LEVEL<=10;
REC_FOO CUR_FOO%ROWTYPE;
BEGIN
OPEN CUR_FOO;
LOOP
FETCH CUR_FOO INTO REC_FOO;
EXIT WHEN CUR_FOO%NOTFOUND;
IF REC_FOO.L=9 THEN
GOTO LEBEL;
END IF;
DBMS_OUTPUT.PUT_LINE('==>'||REC_FOO.L);
<<LEBEL>>
DBMS_OUTPUT.PUT(' ');
END LOOP;
CLOSE CUR_FOO;
END;
==>1
==>2
==>3
==>4
==>5
==>6
==>7
==>8
==>10