sql - 如何增加 Oracle SQL Developer 中的缓冲区大小以查看所有记录？

Question

如何增加Oracle SQL Developer中的缓冲区大小以查看所有记录(默认情况下似乎设置了一定的限制)？任何屏幕截图和/或提示都会非常有帮助。

Answer 1

https://forums.oracle.com/forums/thread.jspa?threadID=447344

相关部分内容如下:

There's no setting to fetch all records. You wouldn't like SQL Developer to fetch for minutes on big tables anyway. If, for 1 specific table, you want to fetch all records, you can do Control-End in the results pane to go to the last record. You could time the fetching time yourself, but that will vary on the network speed and congestion, the program (SQL*Plus will be quicker than SQL Dev because it's more simple), etc.

工具栏上还有一个按钮，即“获取全部”按钮。

FWIW 检索所有记录时要小心，对于非常大的记录集，它可能会导致您遇到各种内存问题等。

据我所知，SQL Developer 在后台使用 JDBC 来获取记录，并且限制是由 JDBC setMaxRows() 过程设置的，如果您可以更改此设置(可能是不支持)那么您也许能够更改 SQL Developer 行为。