Oracle LOOP statement.

Preamble

In Oracle, the LOOP statement is used when you are not sure how many times you want to execute a loop body or execute a loop body at least once.

LOOP statement Syntax

LOOP
{...}
END LOOP;

Statement parameters and arguments

• The code is executed every time you go through a cycle.

You use a LOOP when you are not sure how many times you want to execute the body of the loop.

You can interrupt a LOOP loop with any EXIT operator, or when it encounters EXIT WHEN which takes TRUE.

An example is:

LOOP
monthly_value := daily_value * 31;
EXIT WHEN monthly_value > 4000;
END LOOP;

In this example, the LOOP will stop when monthly_value exceeds 4000.

PL/SQL tutorial: Simple Loop in Oracle Database

About Enteros

Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.