Skip to content
Related Articles

Related Articles

Improve Article
Save Article
Like Article

Area and Perimeter of Rectangle in PL/SQL

  • Last Updated : 04 Oct, 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 value of the length, breadth, and the task is to calculate the area and perimeter of the Rectangle.

Attention reader! Don’t stop learning now. Learn SQL for interviews using SQL Course  by GeeksforGeeks.


Input: l = 2, b = 2
Output: Area = 4, Perimeter = 8

Input: l = 4, b = 8
Output: Area = 32, Perimeter=24

Mathematical Formula:
Area of rectangle:

  Length * Breadth
Perimeter of rectangle:

 2 * ( Length + Breadth)

Below is the required implementation:

-- Declaration statement 
  -- Declaration of length and assigning values 
  l NUMBER(4, 2) := 3; 
  --Declaration of breadth and assigning values 
  b NUMBER(4, 2) := 7; 
  --Declaration of a variable for Area of rectangle 
  a NUMBER(4, 2); 
  --Declaration of a variable for perimeter 
  p NUMBER(4, 2); 
  -- calculate area and perimeter
  a := l * b; 
  p := 2 * (l + b); 
  --Display result 
  dbms_output.Put_line('Area of the rectangle is  ' 
  || a); 
  dbms_output.Put_line('Perimeter of the rectangle is ' 
  || p); 
--ENd program


Area of the rectangle is 21
Perimeter of the rectangle is 20
My Personal Notes arrow_drop_up
Recommended Articles
Page :

Start Your Coding Journey Now!