While 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

While Loop in PL/SQL

PL/SQL while loop is used when a set of statements has to be executed as long as a condition is true, the While loop is used. The condition is decided at the beginning of each iteration and continues until the condition becomes false.

Syntax of while loop:

            
WHILE <condition>   
LOOP statements;   
END LOOP;

Example of PL/SQL While Loop

After executing this , the output is

Let's jump to For Loop in PL/SQL

PL/SQl ExitLOOP

PL/SQL For Loop

Share this page on :