Assign loop counter to pls_integer type variable : PLS_INTEGER « Data Type « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Data Type
  3. PLS_INTEGER

Assign loop counter to pls_integer type variable

  
SQL> create or replace procedure num_test_as_pls is
  2   x pls_integer;
  3   t number := dbms_utility.get_time;
  4   begin
  5       for i in 1 .. 1000 loop
  6          x := i;
  7       end loop;
  8       dbms_output.put_line((dbms_utility.get_time-t)||'cs');
  9   end;
 10  /

Procedure created.

SQL>
SQL>
SQL>








Related examples in the same category

1.PLS_INTEGER variable
2.Check value of PLS_INTEGER type variable
3.Calculation with pls_integer
4.Count with pls_integer type variable
5.PLS_Integer type variable
6.The index variable is a PLS_INTEGER datatype number.
7.Calculate a grand total