Oracle EXIT statement.

Preamble

In Oracle, the EXIT statement is most commonly used to complete a LOOP cycle.

EXIT statement Syntax

EXIT [WHEN boolean_condition];

Options and arguments of the operator

• boolean_condition is not mandatory. It is an exit condition.

Let’s consider an example of using EXIT in Oracle / PLSQL

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

In this example, the loop will end when monthly_value exceeds 4000.

Oracle PL/SQL Tutorials: EXIT and CONTINUE in FOR LOOP

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.