O'Reilly logo

Oracle® PL/SQL® Interactive Workbook, Second Edition by Elena Silvestrova, Benjamin Rosenzweig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 2 PL/SQL Concepts

1)In order to calculate the area of a circle, the circle’s radius must be squared and then multiplied by π. Write a program that calculates the area of a circle. The value for the radius should by provided with the help of a substitution variable. Use 3.14 for the value of π. Once the area of the circle is calculated, display it on the screen.
A1: Answer: Your answer should look similar to the following:
SET SERVEROUTPUT ON 
DECLARE 
   v_radius NUMBER := &sv_radius; 
   v_area NUMBER; 
BEGIN 
   v_area := POWER(v_radius, 2) * 3.14; 
   DBMS_OUTPUT.PUT_LINE 
      ('The area of the circle is: '||v_area); 
END; 

In this exercise, you declare two variables, v_radius and v_area, to store the values for the radius of the circle and its area, respectively. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required