PL SQL For Loop - PL SQL While Loop Example - Loops in Oracle PL SQL - PL SQL Loop

Показать описание

PL/SQL looping statements. My Udemy Courses :

#OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle
Interview Question : What is Anchored data type in PL/SQL, why is it required to be used?

Code for programs :
Example simple loop
=====================
declare
num1 number;
num2 number;
sqr number;
begin
num1 := '&LowerNumber';
num2 := '&HigherNumber';

loop
exit when num1 [greater than] num2;
if mod(num1, 2) = 0 then
sqr := num1 * num1;
end if;
num1 := num1 + 1;
end loop;
exception
When value_error then
end;

Example While Loop
==========================
declare
num1 number;
num2 number;
sqr number;
begin
num1 := '&LowerNumber';
num2 := '&HigherNumber';

While num1 [less than] num2 loop
if mod(num1, 2) = 0 then
sqr := num1 * num1;
end if;
num1 := num1 + 1;
end loop;
exception
When value_error then
end;

Example For Loop
=========================
declare
num1 number;
num2 number;
sqr number;
begin
num1 := '&LowerNumber';
num2 := '&HigherNumber';

for n in num1..num2 loop
if mod(n, 2) = 0 then
sqr := n * n;
end if;
end loop;

exception
When value_error then
end;

Example Reverse For Loop
=============================
declare
num1 number;
num2 number;
sqr number;
begin
num1 := '&LowerNumber';
num2 := '&HigherNumber';

for n in reverse num1..num2 loop
if mod(n, 2) = 0 then
sqr := n * n;
end if;
end loop;

exception
When value_error then
end;