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/practical-sql-masterclass-with-mysql/?couponCode=MYSQL2020JUNE16
Learn MongoDB : https://www.udemy.com/course/mongodb-in-nutshell-example-driven-quick-start-in-mongodb/?couponCode=MONGO2022JULY
Learn Python : https://www.udemy.com/course/python-for-those-absolute-beginners-who-never-programmed/?couponCode=PYTHON2022JULY

#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 : https://www.facebook.com/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;