Home > database >  What is [with] multiple outer_label mechanism? How to write?
What is [with] multiple outer_label mechanism? How to write?

Time:12-05

this is a standard cycle + out of control
 outer_label: BEGIN 
The WHILE loop conditions DO
If out of condition then
Leave outer_label;
end if;
END the WHILE;
END outer_label;


Question:
I also have a judgment, also need to do loops and jump out, the above code to write 2 times?
need to modify?
outer_label 1 ?
or ?
This writing can?
 
Jump out of the first cycle + #
Outer_label: BEGIN
The WHILE loop conditions DO
If out of condition then
Leave outer_label;
end if;
END the WHILE;
END outer_label;

# the second loop + jump out
Outer_label: BEGIN
The WHILE loop conditions DO
If out of condition then
Leave outer_label;
end if;
END the WHILE;
END outer_label;
  • Related