create or replace .... is
start varchar2(10);
finish varchar2(10);
begin
.......................
select to_char(sysdate,'sssss') into start from dual;
--- put your statement here select to_char(sysdate,'sssss') into finish from dual; dbms_output.put_line('elapse time'||(finish-start));
end;
start varchar2(10);
finish varchar2(10);
begin
.......................
select to_char(sysdate,'sssss') into start from dual;
--- put your statement here select to_char(sysdate,'sssss') into finish from dual; dbms_output.put_line('elapse time'||(finish-start));
end;
set autotrace traceonly;不出结果,回显示执行计划,和时间
SQL>set timing on;