Definition:
The Oracle PL/SQL EXIT statement is used to skip the current block. It can be used to terminate loops or stop processing based on a condition you specify. When encountered, an EXIT statement forces a loop to complete immediately and unconditionally. Control is then passed to the next statement (if any).
Example Syntax:
EXIT [ condition ];
The condition can be an expression or a value. For example:
EXIT WHEN core_temperature > 100;
Or
EXIT WHEN total_distance = (25/5);
Example Usage:
The statement below OPENs a cursor C, iterates and fetches the result set, EXITs when the result set is not found, and then closes the cursor.
OPEN C;
LOOP
FETCH C INTO L_VAR1, L_VAR2;
EXIT WHEN C%NOTFOUND;
---
---
END LOOP;
CLOSE C;
Related Links:
