Export Query Results behavior

[NelsonTC]

Hello.

I'm constantly exporting query results to .csv file format and I'm struggling with the current behavior.

The queries I run take a lot of time and when I click Export Query Results... CSV file, PQ/SQL Developer runs the query again doubling the time I need to export the results to file.
If I click the "fetch" green arrows, the application simply requests the rest of the results which was what I expected the Export button to do.

I think that some time ago PL/SQL Developer did that (not restart the query when I clicked Export) so I'm assuming I might have changed some setting.
Can anyone confirm me that or tell me if I'm imagining things?

If it helps, my Oracle\Output preferences are:
[v]Enabled
[v]Clear before execute
Buffer size (0 is unlimited)
[0].

I'm using version 9.0.6.1665 on Windows 7 (64-bit) 6.1 Build 7601 (Service Pack 1).

Thanks,
N

 

[Marco Kalter]

Instead of executing the query you can click on the "Export Query Results" button to the right of the SQL Editor. Now the results will be written directly to a file without any memory overhead and without executing the query twice.

 

[NelsonTC]

Hi Marco.

Thank you for your reply.
My "Export Query Results" button only shows on the bar above the results panel when I click "Execute (F8)", thus running the query twice, first on the Execute and after for the Export.

Is that the only behavior? Isn't there any scenario/configuration when the Export has a similar behavior to the "Fetch additional results" button, resuming the query instead of restarting it?

Regards.

 

[rbrooker]

the export query button appears on the right hand side of the sql window if there is no results bar visible.

just below the up/ down buttons.

im running PLSDv10.

 

[NelsonTC]

Mine doesn't. I'm assuming it's because I'm using version 9.0.
Isn't there any alternative?

 

[NelsonTC]

I'm working on a laptop with policies enforced and limited by the company. I can't update the software to a newer version (and don't even know if that would be possible due to licensing issues) besides many other restrictions.

Does that mean I will always have to run the query twice in order to export the output to a file?

Just yesterday I had to run some 30mins+ queries and left the laptop running during the night, only to find out today that something went wrong (network issues maybe) and the queries didn't finish.
Frustrating.

 

[Tfq]

Looking for a similar solution, I get out of memory error when I run the query and unable to find the direct export button on v6.0.4

 

[Tfq]

Hi,

I'm not using this tool but helping my client to find this button on version 6.0.4, can you tell me how this looks like? Sadly the user guide does not explain each button with graphic.

Thanks in advance!

 

[NelsonTC]

Hi Tfq.

If I don't have it on 9.0, I'd assume it's also not present on 6.0.4. Possible it was introduced in a later updater.

I searched on Google images for screenshots of PL/SQL Developer and found this image which shows the export button on the right side of the window, below the up and down arrows:

Unfortunately, I don't have that button on my PL/SQL version.

 

[Tfq]

Hi Nelson,

Thanks for your quick reply, atleast now I know how it looks like. However, I checked the user guide for version 7 and there is a similar button on the sql window - horizontal toolbar. Could this be that? Do you see similar one in version 9?

Thanks.

 

[NelsonTC]

Hi Tfq.

On my case, it only shows when I clock Execute and the SQL code is run, like I described above on post 49436.

 

[Tfq]

Oh! ok, Thanks. . .