Exporting a query result

[lbkr]

Hi,
I have to export a large query result. Usually I fetch all rows and export to Excel but sometimes the result is so large that I get "out of memory" when I try to fetch all rows.
How can I export all query results into a file without getting this error?
I'm using plsql 6.0.5.931

 

[Marco Kalter]

You can use the "Export Query Results" button. This will (re)execute the statement and write all data directly to a file without any memory overhead.

 

[lbkr]

Hi, thank you for the reply. I can't find "Export Query Results" button in my version of plsql. If I right click the mouse I get the option "Export result" but if I choose that option the program only write the selected rows to the file (the ones that are visible in the query result window). I would like to write all query results to the file without having to click "Fetch last page" - is that possible in any way in plsql 6.0.5.931?

 

[Marco Kalter]

In version 6 this is unfortunately not possible. You would need to upgrade to the current version.

 

[lbkr]

I'll do that - thank you Marco