Docsity
Docsity

Prepare for your exams
Prepare for your exams

Study with the several resources on Docsity


Earn points to download
Earn points to download

Earn points by helping other students or get them with a premium plan


Guidelines and tips
Guidelines and tips

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;