Continue expression in pl / SQl?

Possible duplicate:
& lsquo; CONTINUE & rsquo; keyword in Oracle 10g PL / SQL

I am using Oracle 9i and I want to use the continue statement or its equivalent in PL / SQL. So in oracle 9i there is a keyword called continue. If not, let me know about this solution.

+4
source share
1 answer

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

loop if something then goto continue_label; end if; ... <<continue_label>> null; end loop; 
+8
source

Source: https://habr.com/ru/post/1310522/


All Articles