PLSQL code for writing program in sql, Study Guides, Projects, Research of Database Management Systems (DBMS)

SQL code and Programmable language

Typology: Study Guides, Projects, Research

2016/2017

Uploaded on 05/30/2017

sophia-marie
sophia-marie 🇮🇳

1 document

1 / 1

Toggle sidebar

This page cannot be seen from the preview

Don't miss anything!

bg1
write a plsql code to calculate the area of circle whose readius is less than 5
set serveroutput on
declare
radius float:= 1.0;
area float;
begin
dbms_output.put_line('*AREA OF CIRCLE*');
WHILE radius<=5 LOOP
area:=3.14*radius*radius;
dbms_output.put_line('The area of circle is '||area);
radius:=radius+1;
insert into Store_Circle_Area(radius,area)
values(radius,area);
END LOOP;
end;

Partial preview of the text

Download PLSQL code for writing program in sql and more Study Guides, Projects, Research Database Management Systems (DBMS) in PDF only on Docsity!

write a plsql code to calculate the area of circle whose readius is less than 5

set serveroutput on declare radius float:= 1.0; area float; begin dbms_output.put_line('AREA OF CIRCLE'); WHILE radius<=5 LOOP area:=3.14radiusradius; dbms_output.put_line('The area of circle is '||area); radius:=radius+1; insert into Store_Circle_Area(radius,area) values(radius,area); END LOOP; end;