How to capture the start and end time of a query execution in the Output screen of Toad?
RESOLUTION 1:
Right-click inside Editor and select Desktop Panels | Query Viewer. The Query View tab will be displayed at the bottom of the screen showing information on the queries executed.
RESOLUTION 2:
Use SYSDATE value to capture the start/end timestamps for a query. See the below example and use the F5 or Execute as Script option. The Script Output will display the start/end timestamps of the database.
select to_char(sysdate,'dd-mm-yy hh:mi:ss') from dual;
select * from table;
select to_char(sysdate,'dd-mm-yy hh:mi:ss') from dual;
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center