GitHub

notes on PL SQL loop, functions, cursors, triggers.txt

This structure is the most basic of all the loop constructs including FOR LOOP and WHILE LOOP. This basic LOOP statement consists of a LOOP keyword, a body of executable code, and the END LOOP ...
TechRepublic

Comparing cursor vs. WHILE loop performance in SQL Server 2008

Tim Chapman discusses your iteration choices in SQL Server 2008 and explains why determining which option performs better depends on the situation. In a previous TechRepublic column about SQL Server ...
GitHub

cursor-for-loop-optimization.sql

possible in PL/SQL (and any other language). That way, you give the compiler maximum freedom to optimization. -- Create Driver for Test I generate 100,000 rows for my cursor using by CONNECT BY LEVEL ...
note

Streamlining Data Extraction: SQL Loop Control Techniques to Cleanly Skip Unnecessary Conditions

To all database engineers, thank you for your hard work in daily system development and operations. I am sure that you often have opportunities to utilize iterative processing (loops) within stored ...