user2686860
Reputation: 107
SQL Developer get time when query is run
I am using sql developer to fire some queries. I want to know the time when query has run. I see that when you fire sql query, you can see "Task completed in x seconds". But here I want to see the time when query got execute. Is there a way like showtimestamp or something?
Upvotes: 3
Views: 3576
Answers (1)
Jon Heller
Reputation: 36922
Add select to_char(sysdate, 'YYYY-MM-DD HH24:MI:SS') from dual; if the scripts can be modified.
If that's not an option then right-click on the Worksheet and select SQL History:
Upvotes: 1
Related Questions
- How do I compare execution time of two queries is SQL Developer?
- What is the best way to find the current query time of active queries for a specific user/machine in Oracle SQL Developer for all running queries?
- Time missing when running query using Oracle sqlplus
- Get execution time of sql script in oracle sqlplus
- How to display the last eclapsed time in SqlDevelopper when analysing query
- SQL how to find out execution time
- Date and Time in SQL Developer
- How to use Oracle SQL Date and Time
- Finding Execution time of query using SQL Developer
- Get and store execution time in Oracle