Input a number with a substitution variable and then print its multiplication table using a WHILE loop.
What will be an ideal response?
```
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
```
You might also like to view...
What is true about failover cluster network configuration?
A. The storage network should be on a separate subnet B. NIC addresses on servers must have the same network ID C. You need at least three NICs per server D. The heartbeat should be on the client access network
Which programming language adds object-oriented features to C?
a. Objective C b. PHP c. C# d. C++ e. Java