Disappearing Export Query Icon

[marty]

Note: I am using Windows 7. I was using XP prior to Win7 and did not have the below issue using XP, so I assume this is related to Win7(?)..

When I open Developer, on the right hand side of the app towards the top of the window pane (below the menu icons) there are three icons: an UP icon, a DOWN icon and the Export Query Icon.

What's weird is that after running a query via the Execute icon (where the results post directly into a PL/SQL Developer window) as soon as the query starts, the Export Query icon vanishes. And it remains gone even after the query is done executing.

However, it does show as an menu icon in the pane that divides the sql code from the results. However, this Export Query icon is apparently only good for the results you just ran. So, for example, if after running using the execute button, you now changed a parameter in your sql code, running the Export Query icon (in the divider pane - remember - the other one is still no where to be found!) does no good as it only gives results for whatever has just been ran (and is in the results window/pane).

What I have had to do is copy paste the new sql code into a new window in order to get the Export Query icon to show up again in its spot in the upper right corner of the SQL window!

I have also searched for the Export Query icon via the CUSTOMIZE dialog box (by right clicking in the icon menu area) but do not see it as a choice. Perhaps I overlooked it? Is it supposed to be there?

Anyway, so my question is, is there a way to keep the Export Query icon from disappearing in the first place? Or a better way to 'put it back' than opening a new window? Or maybe it is in the CUSTOMIZE box and I didn't see it? Or something else?

Thanks for any assistance..!

 

[Marco Kalter]

After executing a query the button moves to the result toolbar (between the SQL editor and the results).

 

[marty]

Yes, I understand that. However, at that point, using the Export Query icon will only export the data that has just been generated!!! It will NOT generate results based on any change I make to the query.

As I mentioned above, if after running the query the first time, I now make a change to the query and want to re-execute to generate NEW results based on the query change I just made, I CANNOT use the Export Query icon that is now at the Result Toolbar as this will only export the data that I just ran, NOT generate new data based on the query change I made.

Again, to run the new results, I have to copy the query into a new SQL window in order to get the Export Query icon to show up - which is a pain!

And again, is this icon NOT avaialble via the CUSTOMIZE menu?

Thanks for any additional help..

 

[Marco Kalter]

Yes, I understand that. However, at that point, using the Export Query icon will only export the data that has just been generated!!! It will NOT generate results based on any change I make to the query.

That's correct. You would first need to clear the results (Right-click -> Clear results).

 

[marty]

Thank you, that worked.

To my other question, is this Export Query Icon available (As an icon) in any of the Customize menu item options?

Thanks..

 

[Marco Kalter]

No, it is restricted to the SQL Windows toolbars.

 

[marty]

ok, thanks for your help..