What are the different types of iterative statements?

Iterative Statements in PL/SQL

Iterative control Statements are used when we want to repeat the execution of one or more statements for specified number of times.

There are three types of loops in PL/SQL:

• Simple Loop
• While Loop
• For Loop

1) Simple Loop

A Simple Loop is used when a set of statements is to be executed at least once before the loop terminates. An EXIT condition must be specified in the loop, otherwise the loop will get into an infinite number of iterations. When the EXIT condition is satisfied the process exits from the loop.

General Syntax to write a Simple Loop is

:

LOOP statements; EXIT; {or EXIT WHEN condition;}END LOOP;

These are the important steps to be followed while using Simple Loop.

1) Initialise a variable before the loop body.
2) Increment the variable in the loop.
3) Use a EXIT WHEN statement to exit from the Loop. If you use a EXIT statement without WHEN condition, the statements in the loop is executed only once.

2) While Loop

A WHILE LOOP is used when a set of statements has to be executed as long as a condition is true. The condition is evaluated at the beginning of each iteration. The iteration continues until the condition becomes false.

The General Syntax to write a WHILE LOOP is:

WHILE LOOP statements; END LOOP;

Important steps to follow when executing a while loop:

1) Initialise a variable before the loop body.
2) Increment the variable in the loop.
3) EXIT WHEN statement and EXIT statements can be used in while loops but it's not done oftenly.

3) FOR Loop

A FOR LOOP is used to execute a set of statements for a predetermined number of times. Iteration occurs between the start and end integer values given. The counter is always incremented by 1. The loop exits when the counter reachs the value of the end integer.

The General Syntax to write a FOR LOOP is:

FOR counter IN val1..val2 LOOP statements; END LOOP;
  • val1 - Start integer value.
  • val2 - End integer value.

Important steps to follow when executing a while loop:

1) The counter variable is implicitly declared in the declaration section, so it's not necessary to declare it explicity.
2) The counter variable is incremented by 1 and does not need to be incremented explicitly.
3) EXIT WHEN statement and EXIT statements can be used in FOR loops but it's not done oftenly.

NOTE: The above Loops are explained with a example when dealing with Explicit Cursors.



The java programming language provides a set of iterative statements that are used to execute a statement or a block of statements repeatedly as long as the given condition is true. The iterative statements are also known as looping statements or repetitive statements. Java provides the following iterative statements.

  • while statement
  • do-while statement
  • for statement
  • for-each statement

while statement in java

The while statement is used to execute a single statement or block of statements repeatedly as long as the given condition is TRUE. The while statement is also known as Entry control looping statement. The syntax and execution flow of while statement is as follows.

What are the different types of iterative statements?

Let's look at the following example java code.

Java Program

ipublic class WhileTest { public static void main(String[] args) { int num = 1; while(num <= 10) { System.out.println(num); num++; } System.out.println("Statement after while!"); } }

When we run this code, it produce the following output.

What are the different types of iterative statements?

do-while statement in java

The do-while statement is used to execute a single statement or block of statements repeatedly as long as given the condition is TRUE. The do-while statement is also known as the Exit control looping statement. The do-while statement has the following syntax.

What are the different types of iterative statements?

Let's look at the following example java code.

Java Program

public class DoWhileTest { public static void main(String[] args) { int num = 1; do { System.out.println(num); num++; }while(num <= 10); System.out.println("Statement after do-while!"); } }

When we run this code, it produce the following output.

What are the different types of iterative statements?

for statement in java

The for statement is used to execute a single statement or a block of statements repeatedly as long as the given condition is TRUE. The for statement has the following syntax and execution flow diagram.

What are the different types of iterative statements?

In for-statement, the execution begins with the initialization statement. After the initialization statement, it executes Condition. If the condition is evaluated to true, then the block of statements executed otherwise it terminates the for-statement. After the block of statements execution, the modification statement gets executed, followed by condition again.

Let's look at the following example java code.

Java Program

public class ForTest { public static void main(String[] args) { for(int i = 0; i < 10; i++) { System.out.println("i = " + i); } System.out.println("Statement after for!"); } }

When we run this code, it produce the following output.

What are the different types of iterative statements?

for-each statement in java

The Java for-each statement was introduced since Java 5.0 version. It provides an approach to traverse through an array or collection in Java. The for-each statement also known as enhanced for statement. The for-each statement executes the block of statements for each element of the given array or collection.

🔔 In for-each statement, we can not skip any element of given array or collection.

The for-each statement has the following syntax and execution flow diagram.

What are the different types of iterative statements?

Let's look at the following example java code.

Java Program

public class ForEachTest { public static void main(String[] args) { int[] arrayList = {10, 20, 30, 40, 50}; for(int i : arrayList) { System.out.println("i = " + i); } System.out.println("Statement after for-each!"); } }

When we run this code, it produce the following output.

What are the different types of iterative statements?

What are the different types of iterative statements in Java?

Java programming language provides following types of loop to handle looping requirements. Repeats a statement or group of statements until a given condition is true..
' while' loop..
' do while' loop..
' for' loop..

What are the different types of iterative statement in C?

Iteration statements are most commonly know as loops. Also the repetition process in C is done by using loop control instruction..
For Loop..
While Loop..
Do-while loop..

What are the two types of iterative statements?

7.6 Iteration Statements.
1 The while Statement. The while statement evaluates a control expression before each execution of the loop body. ... .
2 The do Statement. The do statement evaluates the control expression after each execution of the loop body. ... .
3 The for Statement..

What are the types of iterative statements explain with example?

These statements are commonly called as loops. A loop repeatedly executes the same set of instructions until a termination condition is met. Explanation: For example, if we want to print Hello for 10 times, we need to call the print statement 10 times.