I would like to jump out of the current loop in the loop cursor and enter the next cursor loop, how to achieve it?

glister

E.g:

for c1 in cursor1 loop

  if a = 1 then jump out;
 
  -Processing statements;

end loop;

How does the "jump out" realize the function of continue?
Thank you very much!

idpublic

exit;

How does the "jump out" realize the function of continue?
Do you want to jump out or continue?

idpublic

BEGIN
FOR i IN 1..5
LOOP
 IF i> 3 THEN EXIT;
 ELSE
  DBMS_OUTPUT.PUT_LINE (TO_CHAR (i));
  END IF;
END LOOP;
END;
----
1
2
3

whbilly

exit is completely out

海蓝之谜

The jump in Oracle is implemented by GOTO. Generally, this command is not recommended.

for cl in cursor1 loop
   if .. then
      goto cursor2_loc; --Go to the specified position
   end if;
end loop;

<< cursor2_loc >>-define the location of a jump
for c2 in cursor2 loop
    ..
end loop;

glister

The subject of my question is
"Why do you want to jump out of the current loop and enter the next cursor loop in the loop cursor?"

The goal I want to achieve is "to jump out of the current loop and enter the next loop"

But using exit is to exit the entire loop, and I want to continue the loop below.

In addition to the above goto, how can it be done concisely? Thanks a lot!

hzy520cf

for c1 in cursor1 loop

  if a = 1 then do nothing
  else
  -Processing statements;

end loop;

If it meets the exit condition, it will do nothing and continue to loop. This is not enough!

idpublic

BEGIN
FOR i IN 1..5
LOOP
 IF i <> 3 THEN
  DBMS_OUTPUT.PUT_LINE (TO_CHAR (i));
  END IF;

END LOOP;
END;

-------------------------
If it meets the exit condition, it will do nothing and continue to loop. This is not enough!

whbilly

Consider using if conditions instead.