Dark Mode
Image

PL/SQL Loop

PL/SQL Loop

The PL/SQL loops are used to repeat the execution of one or more statements for specified number of times. These are also known as iterative control statements.

Syntax for a basic loop:

 

LOOP  

  Sequence of statements;  

END LOOP;  

Types of PL/SQL Loops

There are 4 types of PL/SQL Loops.

  1. Basic Loop / Exit Loop
  2. While Loop
  3. For Loop
  4. Cursor For Loop

Comment / Reply From