GitHub

-- gen_bind_vars_awr-loop.sql

for this script utl_file is no longer being used. The problem is that some SQL is over 2499 characters in length, and it may be stored as one line in the data dictionary SQLPlus cannot execute lines ...
GitHub

-- sp_WhoIsActive in a loop

-- This script calls the SP_WhoIsActive stored procedure 10 times in a loop with a 5-sec delay, storing the result set in a temp table -- and then displaying the results in descending order of ...
LinkedIn

MS SQL - How to loop through table rows in T-SQL

In this post we will see three ways to iterate through table rows in a loop using T-SQL. I am using Microsoft SQL SERVER 2008 R2. For example you have a few records that you want to loop through and ...
LinkedIn

Configure the SQL Server Integration Services For Loop Container

How can I configure the SQL Server Integration Services For Loop Container? What options are available? How do you establish variables? How can you test the process? The SQL Server Integration ...