Area and Perimeter of a circle in PL/SQL
Last Updated :
04 Jul, 2018
Prerequisite – PL/SQL introduction
In PL/SQL code groups of commands are arranged within a block. A block group related declarations or statements. In declare part, we declare variables and between begin and end part, we perform the operations.
Given the radius of a circle and the task is to find the area and perimeter of the circle.
Examples:
Input: 3
Output: Area = 28.26
Perimeter = 18.84
Input: 7
Output: Area = 153.86
Perimeter = 43.96
Formula for area and perimeter of circle:
Area:
pi * radius * radius
Perimeter:
2 * pi * radius
where pi = 3.14
Below is the required implementation:
DECLARE
area NUMBER(6, 2) ;
perimeter NUMBER(6, 2) ;
radius NUMBER(1) := 3;
pi CONSTANT NUMBER(3, 2) := 3.14;
BEGIN
area := pi * radius * radius;
perimeter := 2 * pi * radius;
dbms_output.Put_line( 'Area = ' || area);
dbms_output.Put_line( ' Perimeter = ' || perimeter);
END ;
|
Output:
Area = 28.26
Perimeter = 18.84
Share your thoughts in the comments
Please Login to comment...