Create a program script that uses a PL/SQL anonymous block to perform the following:

Question

Use a host variable AREA to store the result. Declare a local variable RADIUS with numeric data type. Declare a constant PI with value 3.14. Assign a value to the variable RADIUS by using a substitution variable. Calculate area of a circle by using formula

Then print result in SQL*Plus.

Answer 1

```
SQL> VARIABLE area NUMBER
SQL> DECLARE
2 radius NUMBER(2) := &s_radius;
3 pi CONSTANT NUMBER := 3.14;
4 BEGIN
5 :area := pi * radius * radius;
6 END;
7 /
Enter value for s_radius: 5
old 2: radius NUMBER(2) := &s_radius;
new 2: radius NUMBER(2) := 5;

PL/SQL procedure successfully completed.

SQL> PRINT area

AREA
----------
78.5
```