Write a PL/SQL block to print all odd numbers between 1 and 10 using a basic loop.
What will be an ideal response?
```
SQL> DECLARE
2 v_count NUMBER(2) := 1;
3 BEGIN
4 LOOP
5 DBMS_OUTPUT.PUT_LINE(v_count);
6 v_count := v_count + 2;
7 EXIT WHEN v_count > 10;
8 END LOOP;
9 END;
10 /
1
3
5
7
9
PL/SQL procedure successfully completed.
```
Computer Science & Information Technology
You might also like to view...
A distinct part of a document is called a(n) ________
Fill in the blank(s) with correct word
Computer Science & Information Technology
You should remember that what you do online may be seen by potential employers
Indicate whether the statement is true or false
Computer Science & Information Technology