PL SQL For Loop - PL SQL While Loop Example - Loops in Oracle PL SQL - PL SQL Loop
PL/SQL looping statements. My Udemy Courses :
Learn SQL : https://www.udemy.com/course/practica...
Learn MongoDB : https://www.udemy.com/course/mongodb-...
Learn Python : https://www.udemy.com/course/python-f...
#OraclePLSQL #LearnPLSQL #Crazy4DB #MunshiSir #LearnOracle
Interview Question : What is Anchored data type in PL/SQL, why is it required to be used?
My web site : http://www.oracletrainingnagpur.com
My blog : https://crazy4db.blogspot.in
My facebook page : / crazy4db
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;
dbms_output.put_line ('square of '||num1||' is '||sqr);
end if;
num1 := num1 + 1;
end loop;
exception
When value_error then
dbms_output.put_line ('input must be a number');
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;
dbms_output.put_line ('square of '||num1||' is '||sqr);
end if;
num1 := num1 + 1;
end loop;
exception
When value_error then
dbms_output.put_line ('input must be a number');
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;
dbms_output.put_line ('square of '||n||' is '||sqr);
end if;
end loop;
exception
When value_error then
dbms_output.put_line ('input must be a number');
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;
dbms_output.put_line ('square of '||n||' is '||sqr);
end if;
end loop;
exception
When value_error then
dbms_output.put_line ('input must be a number');
end;