Area and Perimeter of Rectangle in PL/SQL Improve Improve Like Article Like Save Share Report 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. Examples: 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: Perimeter of rectangle: Below is the required implementation: -- Declaration statement DECLARE -- 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); BEGIN -- 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; --ENd program Output: Area of the rectangle is 21 Perimeter of the rectangle is 20 Last Updated : 04 Oct, 2018 Like Article Save Article Previous PLSQL | CHR Function Next Area and Perimeter of a circle in PL/SQL Share your thoughts in the comments Add Your Comment Please Login to comment... Similar Reads Maximum area of a Rectangle that can be circumscribed about a given Rectangle of size LxW Program to find Perimeter / Circumference of Square and Rectangle Largest subset of rectangles such that no rectangle fit in any other rectangle Find the area and perimeter of right triangle in PL/SQL Area and Perimeter of a circle in PL/SQL Area of a Square | Using Side, Diagonal and Perimeter Find minimum area of rectangle with given set of coordinates Number of squares of maximum area in a rectangle Sum of Area of all possible square inside a rectangle Area of Largest rectangle that can be inscribed in an Ellipse Like jit_t Follow Article Tags : SQL-PL/SQL square-rectangle SQL