PL SQL - Largest of 3 numbers

-- Largest among three numbers using PL SQL

declare
a number(10);
b number(10);
c number(10);
begin
a:=&a;
b:=&b;
c:=&c;
if a>b and a>c then        -- checking if a is the largest.
dbms_output.put_line(chr(10)||a||' is largest');
else if b>c then   -- checking if b is the largest.
dbms_output.put_line(chr(10)||b||' is largest');
else    -- c is largest.
dbms_output.put_line(chr(10)||c||' is largest');
end if;
end if;
end;
/

Output

PL SQL - Area of Circle

-- This PL SQL program finds the area of a circle, whose radius is given as input.

declare
a number(10,2);
pi constant number(10,2):=3.14;
r number(10);
begin
r:=&r;
a:=pi*r*r;  -- calculating the area of circle
dbms_output.put_line('area='||a);
end;

Output

PL SQL program to print multiplication table for a number

-- This program prints the multiplication table for any number, the number and the limit should be given as input.

declare
n number(5);
i number(2);
m number(5);
limit number(5);
begin
i:=1;
n:=&n;  -- The number for which multiplication table should be printed.
limit:=&l;  -- This specifies the limit of the table.
dbms_output.put_line('Multiplication table for '|| n);
for i in 1..limit
loop
m:=n*i;
dbms_output.put_line(n||'*'||i||'='||m);
end loop;
end;

Output

PL SQL - sum of numbers from 1 to 100

-- This PL SQL program is used to find the sum of first 100 numbers.

declare
i number(10);
n number(10);
begin
n:=0;
i:=1;
while i<100
loop
n:=n+i;
i:=i+1;
end loop;
dbms_output.put_line('Sum is:'||n);
end;

Output