PLSQL While Loop | Continue | Break Statement

Published: 19 June 2024
on channel: Software Traininings
16
1

While Loop: Sets a condition for the repeated execution of an SQL statement or statement block. The statements are executed repeatedly as long as the specified condition is true. The execution of statements in the WHILE loop can be controlled from inside the loop with the BREAK and CONTINUE keywords.
-If there are multiple statements being enclosed then we can put them under Begin and End Statements.

BREAK: Causes an exit from the innermost WHILE loop. Any statements that appear after the END keyword, marking the end of the loop, are executed.

CONTINUE: Causes the WHILE loop to restart, ignoring any statements after the CONTINUE keyword.


On this page of the site you can watch the video online PLSQL While Loop | Continue | Break Statement with a duration of hours minute second in good quality, which was uploaded by the user Software Traininings 19 June 2024, share the link with friends and acquaintances, this video has already been watched 16 times on youtube and it was liked by 1 viewers. Enjoy your viewing!