declare
t1 timestamp;
t2 timestamp;
l_name varchar2(30);
begin
t1 := systimestamp;
for c1 in (select ename from scott.emp where empno = 7839) loop
l_name := c1.ename;
t2 := systimestamp;
end loop;
dbms_output.put_line('Start: '||t1);
dbms_output.put_line(' End: '||t2);
dbms_output.put_line('Elapsed Seconds: '||TO_CHAR(t2-t1, 'SSSS.FF'));
end; Statement processed.
Start: 09-APR-19 06.11.27.761835 PM
End: 09-APR-19 06.11.27.761926 PM
Elapsed Seconds: +000000 00:00:00.000091000