Control Statements
PL/SQL GOTO
In PL/SQL, GOTO statement makes you able to get an unconditional jump from the GOTO to a specific executable statement label in the same subprogram…
PL/SQL Continue
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…
PL/SQL FOR Loop
PL/SQL for loop is used when when you want to execute a set of statements for a predetermined number of times. The loop is iterated…
PL/SQL While Loop
PL/SQL while loop is used when a set of statements has to be executed as long as a condition is true, the While loop is…
PL/SQL Exit Loop
PL/SQL exit loop is used when a set of statements is to be executed at least once before the termination of the loop. There must…
PL/SQL Case
The PL/SQL CASE statement facilitates you to execute a sequence of satatements based on a selector. A selector can be anything such as variable, function…