• Skip to primary navigation
  • Skip to main content

Tech Honey

The #1 Website for Oracle PL/SQL, OA Framework and HTML

  • Home
  • HTML
    • Tags in HTML
    • HTML Attributes
  • OA Framework
    • Item in OAF
    • Regions in OAF
    • General OAF Topics
  • Oracle
    • statement
    • function
    • clause
    • plsql
    • sql
You are here: Home / Oracle / statement / EXIT Statement in Oracle PLSQL

EXIT Statement in Oracle PLSQL

November 23, 2012 by techhoneyadmin

EXIT statement in Oracle PLSQL is most commonly used to end the LOOP statement’s execution.

The Syntax for the EXIT Statement in Oracle PLSQL is:

EXIT [WHEN boolean_condition];

Example of an EXIT Statement in Oracle PLSQL is:

LOOP
{
  sum := sum + 1;
  EXIT WHEN sum = 35;
}
END LOOP;

The above loop will execute the “sum := sum+1; statement 35 times. The loop will start counting from 1 and as soon as the value of the “sum” variable crosses 35 the loop will terminate.


Filed Under: statement Tagged With: EXIT Statement in oracle plsql, EXIT Statement in oracle sql, EXITSTATEMENTPLSQL, how to use EXIT Statement in oracle database query, how to use EXIT Statement in oracle plsql, how to use EXIT Statement in oracle sql, syntax and example of EXIT Statement in oracle database query, syntax and example of EXIT Statement in oracle plsql, syntax and example of EXIT Statement in oracle sql, using EXIT Statement in oracle database query, using EXIT Statement in oracle plsql, using EXIT Statement in oracle sql

Copyright © 2023 · Parallax Pro on Genesis Framework · WordPress · Log in