SQL>
SQL> set echo on
SQL> set serverout on
SQL>
SQL> declare
2 myStart number;
3 n number := 0;
4 begin
5
6 myStart := dbms_utility.get_time;
7
8 for x in 1 .. 100000
9 loop
10 n := n+1;
11 end loop;
12
13 dbms_output.put_line(round( (dbms_utility.get_time-myStart)/100, 2 ) ||' seconds...' );
14 end;
15 /
.01 seconds...
PL/SQL procedure successfully completed.