SQL
Data Structure
DBMS
PL/SQL
MY SQL
Mongo DB
PostgreSQL
SQL Server
Oracle
Cassandra
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.
- Basic Loop / Exit Loop
- While Loop
- For Loop
- Cursor For Loop