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. Next, you compute the value for the variable v_area with the help of the built-in function POWER and the value of the v_radius. Finally, you display the value of the v_area on the screen.
Assume that number 5 has been entered for the value of the variable v_radius. Then the script produces the following output:
Enter value for sv_radius: 5 old 2: v_radius NUMBER := &sv_radius; new 2: v_radius NUMBER := 5; The area of the circle is: 78.5 PLSQL procedure successfully completed.