There is also "pin data grids":

Toad for Oracle - Beta
1
  • Editor: Added ability to pin data grids (after F9 or CTRL+Enter). Look for the pin icon on the toolbar above the grid.

Could you post an image showing this?

Cheers,
Russ

2

Here's a quick video:

PinGrids

1 Like
3

So, what gets pinned? Is it the full result set including what has not yet been pulled down (i.e., "more rows exist") that can be paged in later, or is it just what is already in the grid?

4

The entire datagrid and underlying query get moved to a new tab. You can still scroll down, edit, export to Excel - anything you can do with a non-pinned grid should work.

5

Excellent. Sounds great. That is definitely something that I will use.

6

I'm glad to hear that. It's been requested a couple of times. Please give it a try while it's still in beta and let us know what you think. There is still a little time before we need to start wrapping things up for 17.0.

7

Yeah, um, well, no. My company IT folks will not install a Beta version of any software no matter how much I beg and plead. I can only ever get an annual update of software versions besides Windows patches. I actually decided to skip 16.3 to wait for 17.0. There is also the government side where their different enclaves have different versions of TOAD one of which is only v.12. It is next to impossible to get all of these synchronized. At least, we have not succeeded so far.

Cheers,
Russ

8

Ah, yeah I think you've mentioned this to me before. No problem. We tested it pretty well, but I haven't received any feedback on it from a real-life user.