-- Using for loop method 1
DECLARE
BEGIN
<<i_loop>> for i in reverse 1..9 loop
<<j_loop>> for j in 1..9 loop
dbms_output.put(i);
exit j_loop when j = i;
end loop;
dbms_output.new_line;
END LOOP;
END;
--Using for loop method 2
DECLARE
BEGIN
<<i_loop>> for i in reverse 1..9 loop
<<j_loop>> for j in 1..i loop
dbms_output.put(i);
end loop;
dbms_output.new_line;
END LOOP;
END;
-- using while loop
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter