Fetching all rows at once

[cipri]

Hi,

I want to show all rows at once but PLSQL Developer has stopped working after 365.000 records.

I changed in Preferences:
- SQL Window - Records per Page: All records
- Maximum result set size (Mb) : 0 (is for unlimited)

Can you help me ?

I've installed PLSQL Developer 32 bit (Trial version).

Regards,
Ciprian

 

[Marco Kalter]

What exactly goes wrong after 365.000 records? Does it simply stop? Are there any error messages?

Note that you should preferably use the "Export Query Results" button to the right of the SQL Window. This way the query results will directly be written to a file, without any memory overhead.

 

[cipri]

Exactly, it simply stop with the error message:

PL/SQL Developer 32 bit has stopped working. A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.

In a data-warehousing it is very diffcult to work with "Export Query Results". We are trying to evaluate your product and I want to know if it's possible to featch all rows at once for large tables.

Regards,
Ciprian

 

[Marco Kalter]

The SQL Window is an interactive tool. Viewing 365.000 records is not really humanly possible. If you want to view a limited set of records you can use an appropriate where clause to limit the query results.

 

[cipri]

There is no way to show more than 365.000 records at once ?

Regards,
Ciprian

 

[Marco Kalter]

Only by exporting them.