开发者

continue statement in pl/SQl? [duplicate]

This question already has answers here: Closed 12 years ago.

Possible Duplicate:

‘CONTINUE’ keyword in Oracle 10g PL/SQL

I am Using Oracle 9i and I want to use continue statement or its equivalent in PL/SQL. So is there any keyword called "continue" in oracle 9i. If n开发者_StackOverflow中文版ot, please let me know the solution for this.


The CONTINUE statement was added in Oracle 11G, it is not available in prior versions. A solution would be to use GOTO:

loop
   if something then
      goto continue_label;
   end if;
   ...
   <<continue_label>> null;
end loop;
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜