Practical Practice 15
Oracle Practice
Write a program to calculate area of an equilateral triangle in PLSQL block.
Write a program to calculate area of an equilateral triangle in PLSQL block.
SOLUTION
--Static code
set serveroutput on;
DECLARE
side NUMBER := 3;
area NUMBER;
BEGIN
area := (SQRT(3) / 4) * POWER(side, 2);
DBMS_OUTPUT.PUT_LINE('The area of the equilateral triangle with side ' || side || ' is ' || area);
END;
/
--Dynamic code
set serveroutput on;
DECLARE
side NUMBER := &side;
area NUMBER;
BEGIN
area := (SQRT(3) / 4) * POWER(side, 2);
DBMS_OUTPUT.PUT_LINE('The area of the equilateral triangle with side ' || side || ' is ' || area);
END;
/
--Dynamic code set serveroutput on; DECLARE side NUMBER := &side; area NUMBER; BEGIN area := (SQRT(3) / 4) * POWER(side, 2); DBMS_OUTPUT.PUT_LINE('The area of the equilateral triangle with side ' || side || ' is ' || area); END; /