oracle登录账号oracle10g不支持continue解决方法

解决方案如下
:采用goto进行跳转

DECLARE   done  BOOLEAN;BEGIN   FOR i IN 1..50 LOOP      IF done THEN         GOTO end_loop;      END IF;   <>  -- not allowed unless an executable statement follows   NULL; -- add NULL statement to avoid error   END LOOP;  -- raises an error without the previous NULLEND;

11g增加continue关键字用法如下

DECLARE   done  BOOLEAN;oracle账号BEGIN   FOR i IN 1..50 LOOP      IF done THEN        continue;      END IF;   END LOOP;  END;
此条目发表在oracle metalink账号分类目录,贴了标签。将固定链接加入收藏夹。