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