hi, can anyone help regarding disply of time elapsed in the answer window. i.e when a query is run the time elapsed is displayed at the left bottom corner.but i want the time elapsed details in the answer set. can i get the details of the time and date the query has been run in the imported file in a notepad. tell me the query to be used thanks
why not run the SELECT DATE,TIME; after your actual query whose result you are exporting, is run. or else you can also get the information from dbc.Acclogtbl, when queried against your username.Include the query shown below after all the queries whose result you are exporting/redirecting into a notepad.however, you should enable Accesslogging on your userId.
select thedate,thetime,username,statementtext from dbc.acclogtbl where thedate=current_date and username=[your userid here];
for eg, for user dbc:- select thedate,thetime,username,statementtext from dbc.acclogtbl where thedate=current_date and username='DBC';
*** Query completed. 4 rows found. 4 columns returned. *** Total elapsed time was 1 second.