Toad World® Forums

TOAD 12.8.0.49 data grids from script in random order, please fix

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:
  1. select start time

  2. select statement I’m timing

  3. 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