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
- Find the area and perimeter of right triangle in PL/SQL
- Area and Perimeter of Rectangle in PL/SQL
- Difference between SQL and PLSQL
- PLSQL | LOG Function
- PLSQL | INSTR Function
- PLSQL | INSTRB Function
- PLSQL | LENGTH2 Function
- PLSQL | SOUNDEX Function
- PLSQL | ASCII Function
- PLSQL | CONCAT Function
- PLSQL | COMPOSE Function
- PLSQL | CHR Function
- PLSQL | ASCIISTR Function
- PLSQL | CONVERT Function
- PLSQL : || Operator
- PLSQL | DECOMPOSE Function
- PLSQL | DUMP Function
- PLSQL | INITCAP Function
- PLSQL | LENGTHC Function
- PLSQL | LENGTHB 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 firstname.lastname@example.org. 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.