Columns render different in Shift-F9 versus F5

Toad for Oracle - Beta
1

I don't know if this is specifically related to the beta but that is what I am using.

When I run a query with Shift-F9, my LARGE NUMBER column renders as a NUMBER
See YELLOW column.

image
image1532×535 23.5 KB

When I run it with F5 as a script, it "helps" me by converting to scientific notation

image
image1357×552 18.8 KB

Now when I SAVE TO EXCEL all the GRIDS, this 1.0000E+14 gets saved as a STRING in the Excel grid and when converted back to a number, they all become 100000000000, which is incorrect; I lose the original values in EXCEL. I like the running many queries with F5 as it creates grids and then can all be saved to EXCEL in a single keystroke, but with data like this, I cannot do that.

Also, in the grid with an SHIFT-F9 query and you selected several rows and Right-Click, you have an option called "Summarize Selected Cells". When you do that same in in a grid that was generated by F5 and is in Script Output and right click on several rows of cells, you don't have that option "Summarize Selected Cells".

Thanks very much.

Jeff Garner

Does it make sense?

2

Hi Jeff,

Yes, that makes total sense. It is not related to beta.

Things happen very differently in F5 vs F9 execution. This topic has come up often enough for me to create this post about it, which I post links to as needed.

Since F5 grids are showing all results as string, that explains why summarize doesn't work. That feature is built into the grid and meant for numeric data. I don't think I'll be able to do anything about that. Re: large numbers in scientific notation after running with F5 - I'll have to get back to you on that. Not sure if I can fix that one or not either, but I feel a little more hopeful about that one.

You make an excellent point about exporting all grids to excel. Below is a workaround for that which works around the scientific notation problem. It is a little bit convoluted, but if a lot of data is involved this will run faster than F5. I agree it would be nice to do this in the Editor. Give me some time to think about that. Maybe I can work something out with the Pinned Grid feature.

MultipleSelectsToExcel

Update: I just found that if you put this at the beginning of your scripts, F5 won't convert your large numbers into scientific notation. It doesn't help with summarizing though.

set numwidth 99;

3

Okay. Thanks for the tip about set numwidth 99; I am going to try it. I have to run something tonight.

Thanks for the great support.

Jeff