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.
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;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With