For 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

For Loop in PL/SQL

PL/SQL for loop is used when when you want to execute a set of statements for a predetermined number of times. The loop is iterated between the start and end integer values. The counter is always incremented by 1 and once the counter reaches the value of end integer, the loop ends.

Syntax of for loop:

            
FOR counter IN initial_value .. final_value LOOP  
LOOP statements;   
END LOOP;

Example of PL/SQL While Loop

After executing this , the output is

Let's jump to CONTINUE in PL/SQL

PL/SQl WhileLOOP

PL/SQL Continue

Share this page on :