Posted by on Jan 24, 2013 | 0 comments

When using nested loops in your PL/SQL code it is beneficial to use  Oracle named loops to make the code easier to read. To name a loop you simply add <<LOOP_NAME>> before the LOOP keyword, then add LOOP_NAME at the end of the END LOOP keyword as shown below <<MAIN_LOOP>> LOOP ...... END LOOP MAIN_LOOP;   Example using...

Read More