Oracle PL/SQL/PL SQL/Timing PL SQL

Материал из SQL эксперт
Перейти к: навигация, поиск

Timed for loop

   <source lang="sql">

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>

      </source>
   
  


Timed unconditional loop

   <source lang="sql">

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>

      </source>