|
SQL>
SQL>
SQL> set serveroutput on size 500000
SQL>
SQL> BEGIN
2
3 <<year_loop>>
4 FOR year_number IN 1800..1995
5 LOOP
6
7 <<month_loop>>
8 FOR month_number IN 1 .. 12
9 LOOP
10 IF year_loop.year_number = 1900
11 THEN
12 dbms_output.put_line('The '||month_number||'th month of '||year_number);
13 END IF;
14
15 END LOOP month_loop;
16
17 END LOOP year_loop;
18
19 END;
20 /
The 1th month of 1900
The 2th month of 1900
The 3th month of 1900
The 4th month of 1900
The 5th month of 1900
The 6th month of 1900
The 7th month of 1900
The 8th month of 1900
The 9th month of 1900
The 10th month of 1900
The 11th month of 1900
The 12th month of 1900
PL/SQL procedure successfully completed.
SQL>
SQL>
|