11.Inner Loop and Outer Loops

PL/SQL

Inner Loop and Outer Loops :

Inner Loop: A Loop inside a loop is called inner loop
Outer Loop: Loop which performs another loop

syntax: For var in start_Val .. end_value
Loop
statement(s)
for var in start_val..end_val
loop;
statement(s)
end loop;
end loop;


Example: Print softare 5 times, and each time print hardware 10 times

begin
for i in 1..5
loop
dbms_output.put_line (i||’ software’);
for j in 1..10
loop
dbms_output.put_line (j||’ Hardware’);
end loop;
end loop;
end;

1 softare
1 hardware
2 hardware
3 hardware
4 hardware
5 hardware
6 hardware
7 hadrware
8 hadrware
9 hadrware
10 hadrware
2 software
1 hadrware
2 hadrware
3 hadrware
4 hadrware
5 hadrware
6 hadrware
7 hadrware
8 hadrware
9 hadrware
10 hadrware

3 software
1 hadrware
2 hadrware
3 hadrware