Declare dbms_utility.get_time as a variable default value : dbms_utility « PL SQL Programming « Oracle PL/SQL Tutorial






SQL> set echo on
SQL>
SQL>
SQL> create table t ( x int );

Table created.

SQL>
SQL> set serveroutput on
SQL>
SQL> declare
  2          l_start number default dbms_utility.get_time;
  3  begin
  4          for i in 1 .. 1000
  5          loop
  6                  insert into t values ( 1 );
  7          end loop;
  8          commit;
  9          dbms_output.put_line ( dbms_utility.get_time-l_start || ' hsecs' );
 10  end;
 11  /
19 hsecs

PL/SQL procedure successfully completed.

SQL>
SQL>
SQL>
SQL> drop table t;

Table dropped.

SQL>
SQL>








24.26.dbms_utility
24.26.1.dbms_utility.get_time
24.26.2.Declare dbms_utility.get_time as a variable default value