Declare variable as a loop counter : Variable Declare « PL SQL « Oracle PL / SQL






  1. Oracle PL / SQL
  2. PL SQL
  3. Variable Declare

Declare variable as a loop counter

SQL>
SQL>
SQL> -- unconstrained loop: exit when
SQL>
SQL>
SQL>  declare
  2      l_loops number := 0;
  3    begin
  4      dbms_output.put_line('Before my loop');
  5
  6      loop
  7        exit when l_loops > 4;
  8        dbms_output.put_line('Looped ' || l_loops || ' times');
  9        l_loops := l_loops + 1;
 10      end loop;
 11
 12      dbms_output.put_line('After my loop');
 13    end;
 14    /
Before my loop
Looped 0 times
Looped 1 times
Looped 2 times
Looped 3 times
Looped 4 times
After my loop

PL/SQL procedure successfully completed.

SQL>








Related examples in the same category

1.Variables and Constants
2.Defining the Indefinable: NULL
3.Raise the VALUE_ERROR exception
4.Raise the 'no data found' exception
5.Declare variables which will be used in SQL statements