Good Morning Team,
I was surprised this morning to see the data grids from run a script (F5 in editor) are no longer in execution order in TOAD 12.8.0.49. Each run of the script puts the grids in a different order. Can the order be restored to the order run in the script, like all prior versions of TOAD?
Larry Wickliffe
Performance and Tuning Services Lead, Performance Management Branch
Office of Information Systems and Technology (OIST)
Employment and Training Administration (ETA). US Department of Labor
Wickliffe.Larry@dol.gov: 202-693-3485
l.wickliffe@computer.org; 703-508-4945
Good Morning Team,
This is a bigger issue than I originally thought; yesterday running a simple script:
-
select start time
-
select statement I’m timing
-
select end time
the script output selected the latest time for the first select statement! It is not the translation to grid that is wrong; the script output data does not match the headings!
Example script attached:
Larry Wickliffe
Performance and Tuning Services Lead, Performance Management Branch
Office of Information Systems and Technology (OIST)
Employment and Training Administration (ETA). US Department of Labor
Wickliffe.Larry@dol.gov: 202-693-3485
l.wickliffe@computer.org; 703-508-4945
SCSEP Core Measures - Employment Retention_Original.sql (2.53 KB)
My apologies; the error is mine. I had month in lieu of minutes in my select for timing. there is nothing to fix in TOAD.
corrected time code
select to_char(SYSTIMESTAMP,‘HH24:MI:SSxFF’) as “Start” from dual;
– code to time
select to_char(SYSTIMESTAMP,’HH24:MI:SSxFF’) as “End” from dual;
Larry Wickliffe
Performance and Tuning Services Lead, Performance Management Branch
Office of Information Systems and Technology (OIST)
Employment and Training Administration (ETA). US Department of Labor
Wickliffe.Larry@dol.gov: 202-693-3485