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