timing 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.15
SQL>
SQL> set timing off
SQL>
SQL>
SQL>
Related examples in the same category