get_time.sql

set serveroutput on
declare
   time_before binary_integer;
   time_after binary_integer;
   ln number(10);
begin
   time_before:=dbms_utility.get_time;
   dbms_output.put_line(to_char(sysdate));
   select count(*) 
   into ln
   from application ;
   time_after:=dbms_utility.get_time;
   dbms_output.put_line(to_char(sysdate));
  dbms_output.put_line(time_after- time_before);
end;
/