continue statement in pl/SQl? [duplicate]
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;
精彩评论