How to Measure Elapsed Time in PLSQL
- Rumesh Aponso (RMAX)
- Nov 5, 2024
- 1 min read
Updated: Nov 22, 2024
DECLARE
t1 timestamp;
t2 timestamp;
BEGIN
t1 := systimestamp;
FOR i IN 1..1000 LOOP
Dbms_Output.Put_Line(TO_CHAR(i));
END LOOP;
t2 := systimestamp;
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;Output:


Useful Links:
