Timed for loop : Timing PL SQL « PL SQL « Oracle PL / SQL






Timed for loop


SQL>
SQL> -- timed for loop
SQL>
SQL>
SQL>  set timing on;
SQL>
SQL>  declare
  2      some_string varchar2(255);
  3    begin
  4      for idx in 1 .. 100000 loop
  5        some_string := rpad('*',254,'*');
  6      end loop;
  7    end;
  8    /

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.18
SQL>
SQL>   set timing off;
SQL>
SQL>

           
       








Related examples in the same category

1.Timed unconditional loop