SQL> -- timed unconditional loop
SQL>
SQL> set timing on;
SQL>
SQL> declare
2 l_idx pls_integer := 0;
3 l_some_string varchar2(255);
4 begin
5 loop
6 l_idx := l_idx + 1;
7 exit when l_idx = 100000;
8 l_some_string := rpad('*',254,'*');
9 end loop;
10 end;
11 /
PL/SQL procedure successfully completed.
Elapsed: 00:00:00.28
SQL>
SQL> set timing off;
SQL>
SQL>
|