Write a PL/SQL block to find the square, cube, and double of a number inputted with a substitution variable, and print results using built-in package DBMS_OUTPUT.

Question

What will be an ideal response?

Answer 1

```
SQL> SET SERVEROUTPUT ON
SQL> DECLARE
2 n NUMBER(2);
3 square NUMBER(3);
4 cube NUMBER(4);
5 double NUMBER(3);
6 BEGIN
7 n := &number;
8 square := n * n;
9 cube := n * n * n;
10 double := n * 2;
11 DBMS_OUTPUT.PUT_LINE('number is ' || n);
12 DBMS_OUTPUT.PUT_LINE('square is ' || square);
13 DBMS_OUTPUT.PUT_LINE('cube is ' || cube);
14 DBMS_OUTPUT.PUT_LINE('double is ' || double);
15 end;
16 /
Enter value for number: 3
old 7: n := &number;
new 7: n := 3;
number is 3
square is 9
cube is 27
double is 6

PL/SQL procedure successfully completed.
```