Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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 not, please let me know the solution for this.

like image 449
i2ijeya Avatar asked Feb 26 '23 23:02

i2ijeya


1 Answers

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;
like image 115
Tony Andrews Avatar answered Mar 05 '23 20:03

Tony Andrews