Example code:
begin
for i in 1 .. 100
loop
dbms_output.put_line ('Iteration:' || i || 'Start');
if mod (i, 2) = 0
then
dbms_output.put_line (
'skip and move on to next record-Condition 1 satisfied');
continue;
end if;
dbms_output.put_line ('Condition 1 failed:' || i);
if mod (i, 5) = 0
then
dbms_output.put_line (
'skip and move on to next record-Condition 2 satisfied');
continue;
end if;
dbms_output.put_line ('Condition 2 failed:' || i);
if mod (i, 11) = 0
then
dbms_output.put_line (
'skip and move on to next record-Condition 3 satisfied');
continue;
end if;
dbms_output.put_line ('Condition 3 failed:' || i);
dbms_output.put_line ('Iteration:' || i || 'End');
end loop;
end;
No comments:
Post a Comment