Input a number with a substitution variable and then print its multiplication table using a WHILE loop.

Question

What will be an ideal response?

Answer 1

```
SQL> CREATE TABLE item(ItemNum NUMBER(2));

Table created.

SQL> BEGIN
2 FOR num IN 1..5 LOOP
3 INSERT INTO item VALUES(num);
4 END LOOP;
5 END;
6 /

PL/SQL procedure successfully completed.

SQL> SELECT * FROM item;

ITEMNUM
----------
1
2
3
4
5
```