Loop | PL/SQl

Analyze Code

Page Index

PL/SQL Introduction

Getting Started
PL/SQL Variables
PL/SQL Constant

Control Statements

PL/SQL IF
PL/SQL Case
PL/SQL Loop
PL/SQL ExitLoop
PL/SQL WhileLoop
PL/SQL For Loop
PL/SQL Continue
PL/SQL GOTO

PLSQL Concepts

PL/SQL Procedure
PL/SQL Function
PL/SQL Cursor
PL/SQL Exception
PL/SQL Trigger

Loop in PL/SQL

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

Now that you know what is loop in PL/SQL, let's jump to ExitLoop in PL/SQL

PL/SQl IF

PL/SQL ExitLOOP

Share this page on :