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行为。