Input a number with a substitution variable and then print its multiplication table using a WHILE loop.
What will be an ideal response?
```
SQL> DECLARE
2 num NUMBER(2) := &number;
3 counter NUMBER(2) := 1;
4 BEGIN
5 WHILE counter <= 12 LOOP
6 DBMS_OUTPUT.PUT_LINE(num||'*'||counter||'='||num*counter);
7 counter := counter + 1;
8 END LOOP;
9 END;
10 /
Enter value for number: 5
5*1=5
5*2=10
5*3=15
5*4=20
5*5=25
5*6=30
5*7=35
5*8=40
5*9=45
5*10=50
5*11=55
5*12=60
PL/SQL procedure successfully completed.
```
You might also like to view...
Google ________ is a specialized search tool that searches scholarly literature such as peer-reviewed papers, theses, and publications from academic organizations
Fill in the blank(s) with correct word
If you deactivate the Maintain aspect ratio button between the W and H text boxes, any change you make to one will automatically be made to the other.
Answer the following statement true (T) or false (F)
____ are areas on the bottom and right sides of windows that allow visitors to scroll through page content.
A. Menu bars B. Tool bars C. Scrollbars D. Status bars
Which term refers to the physical separation of your network from every other network?
A. Secure Web B. Isolation C. Black hole D. Air gap.