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.
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:
pi * radius * radius
2 * pi * radius
where pi = 3.14
Below is the required implementation:
Area = 28.26 Perimeter = 18.84
- Area and Perimeter of Rectangle in PL/SQL
- Find the area and perimeter of right triangle in PL/SQL
- Comparisons between SQL vs PLSQL
- SELECT INTO statement in SQL
- Pivot and Unpivot in SQL
- Common error in Group By
- Categories of SQL Functions
- Query to find 2nd largest value in a column in Table
- Comparisons between Oracle vs SQL Server
- SQL vs NoSQL: Which one is better to use?
- What are the Best Ways to Write a SQL Query?
- Mathematical functions in MySQL
- MySQL | Ranking Functions
- MySQL | DEFAULT() Function
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.