Continue in PL/SQL

The continue statement is used to exit the loop from the reminder if its body either conditionally or unconditionally and forces the next iteration of the loop to take place, skipping any codes in between.

The continue statement is not a keyword in Oracle 10g. It is a new feature encorporated in oracle 11g.

For example: If a continue statement exits a cursor FOR LOOP prematurely then it exits an inner loop and transfer control to the next iteration of an outer loop, the cursor closes (in this context, CONTINUE works like GOTO).

Syntax of continue: continue;

Example of Continue in loop

After executing this , the output is

Let's jump to GOTO statement in PL/SQL

Share this page on :

FaceBook Whatsapp Twitter