Author: B D

In this chapter, we will discuss arrays in PL/SQL. The PL/SQL programming language provides a data structure called the VARRAY, which can store a fixed-size sequential collection of elements of the…

The string in PL/SQL is actually a sequence of characters with an optional size specification. The characters could be numeric, letters, blank, special characters, or a combination of all. PL/SQL…

A GOTO statement in PL/SQL programming language provides an unconditional jump from the GOTO to a labeled statement in the same subprogram. NOTE − The use of the GOTO statement is not recommended…

The CONTINUE statement causes the loop to skip the remainder of its body and immediately retest its condition prior to reiterating. In other words, it forces the next iteration of the loop…

The EXIT statement in PL/SQL programming language has the following two usages − When the EXIT statement is encountered inside a loop, the loop is immediately terminated and the program control resumes…

PL/SQL allows using one loop inside another loop. The following section shows a few examples to illustrate the concept. The syntax for a nested basic LOOP statement in PL/SQL is…

A FOR LOOP is a repetition control structure that allows you to efficiently write a loop that needs to execute a specific number of times. Syntax FOR counter IN initial_value .. final_value…

A WHILE LOOP statement in PL/SQL programming language repeatedly executes a target statement as long as a given condition is true. Syntax WHILE condition LOOP    sequence_of_statements END LOOP; Example DECLARE    a number(2)…

The basic loop structure encloses a sequence of statements in between the LOOP and END LOOP statements. With each iteration, the sequence of statements is executed, and then control resumes at the top of…

In this chapter, we will discuss Loops in PL/SQL. There may be a situation when you need to execute a block of code several times. In general, statements are executed…