How can we use loop in database to repeat some queries ?

Answer 1

'While' works in SQL Server 2008 & above.

USE AdventureWorks2012;
GO
WHILE (SELECT AVG(ListPrice) FROM Production.Product) < $300
BEGIN
UPDATE Production.Product
SET ListPrice = ListPrice * 2
SELECT MAX(ListPrice) FROM Production.Product
IF (SELECT MAX(ListPrice) FROM Production.Product) > $500
BREAK
ELSE
CONTINUE
END

Answer 2

in oracle you need to learn PL/SQL. SQL natively do not support looping.

Answer 3

by using pl/SQL we can do loop operations.

Answer 4

by loop some queries or repeat transactions. I think you means jobs ?